Formatconditional formattingformula is


=C3-TIME(0,0,5)=C2

then click the format button and select a red font and click OK twice


Of course 1.33.672 is text unless you have changed you time delimiter,
you need to enter the times as 0:01:33.672
and format the cell as mm:ss.000


Make sure your regional settings are 24 hour and not AM/PM or else it would
look strange in the formula bar with
12:01:34 AM

--


Regards,


Peo Sjoblom

"PAULANDBEX24" wrote in message
...
I want to change the colour of the number in cell C3 (to red) when the time
is 5 seconds greater than in C2

They are lap times ie 1min 33 seconds . 672
C3 = 1.39.672 current time
C2 = 1.33.672 best time

I used to be able to do this easily in the previous office but cant get
office 2007 to do it.
Please can someone help.