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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell font color if time is> by 15 minute intervals upto 2h 1
Change cell font color if time is> by 15 minute intervals upto 2hr 5
Insert text depending on font colour 2
How do I get total amount of hours in time format 3
How do I stop the font from changing colour automatically? 1
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 5
textbox font colour 2
Adding Times up 3

Back
Top