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?

Put the first condition as if Cell is equal to 0

and the second as Formula is =ISBLANK(A1)


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551952

Try...

First condition: (RED)

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

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

HTH

" wrote:

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?