Conditional formating condition..?

[Phil C]

Hi All

I have 2 CF conditions associated with a cell (C14), one of which is:

Formula is =OR($C$4="Fred SOMEBODY",C14<>"10:30:00")
What happens when this is true isn't important/relevant.

The value in the cell appears as 10:30 (formatted as custom/hh:mm) but the
value in the 'formula window' is actually 10:30:00.
This type of condition works fine when the cell contains a simple number (or
text) but I can't get it to work for either times or dates.
I have tried it with and without the inverted commas (around the time value)
and have tried using 10:30 as well as 10:30:00, without success.

Is there a trick?

Thanks, Phil

 

[Stephen Bye]

Try
C14<>TIMEVALUE("10:30:00")
instead of
C14<>"10:30:00".