Creating IF formula that colors a cell [Closed]

Report
-
 kong -
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 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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