Click in the cell, then:
<Format <Conditional Formatting

And you'll see any *formatting* formulas for that cell.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"TechNoFear" wrote
in message ...

Hi RD,

if it isn't a formula, then there must be another way of affecting
display.

This particular column is green in colour and empty.

A user types in a value in the format nn:nn i.e, a time like 4:30

If the time is before 05:00 hours, the cell remains green, however, if
the time is later the cell turns red.

I presumed it was a formula, can you tell me how it's done please?


tia,


--
TechNoFear
------------------------------------------------------------------------
TechNoFear's Profile:
http://www.excelforum.com/member.php...o&userid=35622
View this thread: http://www.excelforum.com/showthread...hreadid=554009