Conditional formatting formula question
 

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!

Conditional formatting formula question
 

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


"Simon" wrote:

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!