View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default displaying formulas

"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?


Conditional formatting
--
David Biddulph