1. Stop using all caps, it is considered shouting, this is a peer to peer
newsgroup/forum.

I have 2007 as well as 2003 on my PC and it works perfectly fine there.
Select C3,
on the Home tab click the conditional formatting icon, select highlight cell
rules and from the
options select more rules, from the select rule type select "use a formula
to determine which cells to format"

Put the formula in the "format values where this formula is true:" and click
the format button and
select a red font and click OK twice.

I just tested it and it works in all versions that has this functionality.
If not your data is not what it looks
like.


--


Regards,


Peo Sjoblom

"PAULANDBEX24" wrote in message
...
THANKS BUT IT HAS NOT WORKED.

BOTH CELLS ARE FORMATTED IN TIME with 24 hr clock
I inputted your formula but nothing has changed
This seems to be the formula i used in office 2003 but i am now using
office
2007.
Any ideas