In Excel, how would I perform the following using the
- If cell is empty then set the background color to red.
- If cell has a value then set the background color to green.
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