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

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.

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

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$1TIME(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$1TIME(0,30,0)

Does that help?

"Rico Turkses the 3rd" wrote:

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.