Conditional formatting help

S

sandip.dhamapurkar

I have 00:00:00 (time format [hh]:mm:ss) in cell A1
I have nothing in cell A2 (Its completely BLANK)

I want to set a conditional formatting to display red color if the
value is 00:00:00 and blue color if the cell is blank. The conditional
formatting does not work as it treats 00:00:00 and BLANK both as ZERO

Can anybody help?
 
B

Bearacade

Put the first condition as if Cell is equal to 0

and the second as Formula is =ISBLANK(A1)
 
T

Toppers

Try...

First condition: (RED)

Formula is:
=AND(A1<>"",A1=0)

Second condition: (BLUE)
Formula is:
=A1=""

HTH
 
Top