It took me hours to work this out, also
You need to use a formula in a Conditional format. I have one in my
timesheet to remind me to update the date...
=$C$46<TODAY()-20
That says "Turn this cell pink if the date in Cell C46 is more than 20 days
earlier than today". Remember that the "Today()" function returns the
number of days since 1904. Subtract 20 and you have the date from three
weeks ago...
Here's the one I use for a date greater that two weeks in the future, to
turn the cells Amber... =$C$46>NOW()+14
Once you get this formula working in once cell, Copy it, then use Edit>Paste
Special>Paste Formats to copy the formatting to the other cells you want to
colour.
In your case, remove the dollar signs from the cell reference, then you will
be able to Paste>Special down the whole column.
Cheers
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have to track
certifications for many people, I want to have a alert come up prior to the
recertification date. I wanted to have the dates show up in a different color
which i was going to use the conditional formatting. I am having problems
setting up a formula to trigger the color change. Any help would be greatly
appreciated, Tried the E date and date feature but had no luck
This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
