Formatting Cells

[GlennO66]

Hello

The cell is already formatted to display time using
Format==>Cells==>Custom==>[$-409]h:mm AM/PM;@

I want the font to change color if a time greater than
6:00 pm is entered. Is there any way to do this?

Thanks

 

[Jay Gustafson]

GlennO66,

Format > Conditional Formatting >

Cell Value Is : Greater Than : 6:00 PM

Then hit the format button and format as you wish.

 

[Juan Sanchez]

One way:

Format.Conditional Format. Cell value Is Greater Than .75
OR
Format.Conditional Format. Cell value Is Greater Than =Time
(18,0,0)

Format to taste...

Regards
Juan