View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PAULANDBEX24 PAULANDBEX24 is offline
external usenet poster
 
Posts: 3
Default Conditionl format a cell to change text colour

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.