Conditional formatting formula question

S

Simon

Using conditional formatting, what would the formula be if cell A2 was to be
highlighted red if empty but only if cell A1 contained data?

Its a Monday and my head hurts!

Any suggestions would be great!
 
J

JLatham

In conditional formatting for A2, choose Formula Is and use this formula
=AND(A1<>0,A2=0)
 
Top