In Excel, how would I perform the following using the IF
condition?
 If cell is empty then set the background color to red.
 If cell has a value then set the background color to green.
In Excel, how would I perform the following using the



You could apply a regular red fill, then use conditional formatting to make it green if populated, e.g. in conditional formatting use the "use a formula to determine which cells to format" option with the formula
assumes formatting applied to cell A1, change as appropriate. For a range of cells just write the formula for the top left cell, e.g. to format B3:J10 this way select that range and use


