[SOLVED] if cell is blank, color another cell? - Excel Help Forum
Aug 2, 2006 · RE: if cell is blank, color another cell? You can use conditional formating (menu Format) in A1, set the condition with "Formula Is" and use the following formula: =ISBLANK …
Calc howto: conditional format a row based upon a column
Aug 29, 2013 · Open both files at the same time Copy the empty sheet (with the conditional formatting) from the first file to the second file Copy all the data you want formatted onto the …
Conditional format to add borders [SOLVED] - Excel Help Forum
Apr 29, 2018 · Re: Conditional format to add borders I don't think conditional formatting is what you need here. If you have a UserForm that is stamping data to the worksheet then have it …
Changing cell color based on presence of value in another cell.
Apr 17, 2025 · Re: Changing cell color based on presence of value in another cell. Use Conditional Formatting and choose to use a formula. First select all the cells you want to …
Applying conditional formatting to multiple individual cells
Nov 5, 2024 · Goal: change background color based on value relative to the value of a cell. (i.e. I want the background of B1, C1, and D1 to be red if higher than A1, and green if lower) …
Excel Conditional Formatting Based on Another Cell [SOLVED]
Jul 5, 2025 · Re: Excel Conditional Formatting Based on Another Cell Your screen shot doesn't show any values in column A which contain "Off". Typically, you would select the whole range …
Conditional formatting based on the formula result value in a cell
Jan 27, 2017 · Hello, I have a formula in a cell that based on the result, I want to be able to apply a conditional format. I need the formula in the cell to calculate first, then, based on the result …
Color scale conditional formatting based on another cell's value …
Oct 9, 2015 · Color scale conditional formatting based on another cell's value In column F, I have a summary total number of customers that will be lost over a certain time at a given location …
Conditional Formatting Rule to insert text into a blank cell if …
Jan 11, 2016 · I would like to learn how to code a Conditional Format Rule or function that would add text to column "A" cells if the company name (Column B) contains text that I specify. …
Conditional formatting - sum of two cells [SOLVED] - Excel Help …
Jan 10, 2013 · Re: Conditional formatting - sum of two cells test1.xls sorry, it was my fault, i uploaded an incomplete excel. I uploaded here a new one. the formulas you both gave me …