try using =0 in the Conditional formatting

"Minitman" wrote:

Greeting,

I have a spreadsheet where I need to high light rows which have a time
value of 0:00 in column B. Column B has many time figures and a few
empty cells. I am interested only in those cells with the value of
"0:00" (12:00 o'clock midnight)

How do I detect this time value in column B and what would a CF
formula look like to do this?

Any help will be greatly appreciated, thanks.

-Minitman