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

  • Thread starter Rico Turkses the 3rd
  • 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.
 
T

teylyn

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
Splitting appointment records in to 15 minute time bands 3
How do I stop the font from changing colour automatically? 1
How do I get total amount of hours in time format 3
How do I get total hours from 2 date/time cells? 4
How do I round times to 15 minute increments? 2

Top