Hi!

I'm puting a sheet together with all of the eqipment i have in my lab. I have a column with all of the callibration dates in it. I want to add conditional formatting to turn the values red if it is past due for calibration and yellow if it will be due for callibration with in the next 14 days.

I'm using the =now() function to get the current date.

example:

5/7/08 - todays date
5/6/08 - RED
5/14/08 - YELLOW

I hope this is enough info, thanks!