color coded dates
 

i am making a spreadsheet to track training. I put in completed dates and
when they come within 90 days of being due i want the cell to turn orange,
and when they are within or past 30 days turn red. the rest of the time i
want them all green.

color coded dates
 

See http://www.xldynamic.com/source/xld.CF.html#due

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"tbird333" wrote in message
...
i am making a spreadsheet to track training. I put in completed dates and
when they come within 90 days of being due i want the cell to turn orange,
and when they are within or past 30 days turn red. the rest of the time i
want them all green.

color coded dates
 

Use conditional formatting based on formula comparing to function =Now()

color coded dates
 

If all the other times you want them green, first set the font to green for
all of the dates.

For the rest, I'm just guessing at the exact setup of what you're looking
for, so I created a dueDate in cell A1. And I had the dates you're concerned
with be in column B. Then I created two Conditional formats:

-- the first is:
=((A1 - $B1) < 30)
And I set the formatting for this one to have the font be red.

-- The second is:
=((A1 - $B1) < 90)
And I set the formatting for this one to have the font be orange.

If you can get the gist of what to do from this, you can change the colors
and the exact forumula in the conditional formatting to what you're really
looking for.

[also, if you're familiar with setting a cell to a name, I set the cell A1
to be 'dueDate', so my actual condtional formats were essentially:

=((dueDate - $B1) < 90)

hth



"tbird333" wrote:

i am making a spreadsheet to track training. I put in completed dates and
when they come within 90 days of being due i want the cell to turn orange,
and when they are within or past 30 days turn red. the rest of the time i
want them all green.