Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

an expiry date

Status
Not open for further replies.

accessible

Technical User
Aug 12, 2001
3
AE
Hi, I have been searching the site for 3 days but could not find an answer to my problem.
I have several tests in columns in a spreadsheet and dates are the rows.These tests are done at irregular intervals.When they are not performed there is nothing in the fields.When I enter a new row with today date, I want a kind of conditional formating for the tests which are overdue from ,let us say, 6 months or 1 year. I can not figure out how to do that.
Can you help?

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top