time = say 05:00, how do I change font colours at 15 minute incrim

  • Thread starter Thread starter Rico Turkses the 3rd
  • Start date Start date
R

Rico Turkses the 3rd

Hi, I need to change font colours @ 15 minute incrimants.

if c1 is 05:00 how do I get the font to change colour if d1 is > by
15,30,45,60,75,80 minutes etc.

Blue if > by 15, red if > by 30, yellow if > by 45 etc.

I hope you understand this explanation.

Thank you in advance,

Extreme novice.
 
Hi,
you can use conditional formatting. In Excel 2003 you can only have three
conditional formats, but if you're using 2007, there are more.

in 2003: select C1, click Format - Conditional formatting, select "Formula
is" and enter

=$D$1-$C$1>TIME(0,15,0)

click the format button to select a font color.

then click ADD to add another condition for the next increment

=$D$1-$C$1>TIME(0,30,0)

Does that help?
 
Back
Top