View Single Post
  #5   Report Post  
David McRitchie
 
Posts: n/a
Default

I don't think she really got any results, at least not what she was
expecting. Worksheet formula would not allow it. Errors in
Conditional Formatting will not produce an error -- that is the nature
of the beast -- it just reduces the entire statement like any other
statement to True or False. In other words it is a good idea
to check such syntax or statements on the worksheet to check
their validity and that they are working as desired.

"Peo Sjoblom" wrote in messagel...
I don't think you can enter today like that, both the conditional formatting
and regular cell entries refuse to accept it so I don't understand how the
OP can get any results at all?