Creating IF formula that colors a cell

Closed
Helene - Oct 19, 2009 at 07:44 AM
 kong - Nov 19, 2009 at 04:38 AM
Hello,
I have a question re. an IF formula. I am creating a table, where I want Excel to color a cell in red, if no value has been entered. Colleagues tell me that I have to use a macro, but I am not sure how to. Any ideas?
Thanks in advance,
Helene

2 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 19, 2009 at 10:06 AM
Hello
Just conditional format the cell
you have to use a formula CELLADDRESS="" where you have to change CELLADDRESS with the cell address of first cell of such cells
0