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!
Select cell and invoke the Conditional Format dialogue from the Format menu..
Cell Value is >> Less than >> =Today()
Click Format and choose Red from Pattern tab.
Click Add
Cell Value is >> Between >> =Today() >>> =TODAY()+14
Click Format and choose Yellow from Pattern tab.
Click Ok.
Click Ok to finish.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
thanks, I will give that a shot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks