Conditional Formatting

[wookeymonster]

I haven’t used excel in years. How do I format a cell to be red when the cell is blank. Once something is entered into the cell, the cell is no longer red. Please and thank you.

 

[James006]

Hello,

You can add your own custom formula : =A1=""

HTH

 

[sandy666]

or
select cells
---

• Conditional formatting
• New rule
• Format only cells that contain
• Format only cells with: select Blanks
• set format as you wish