Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating
=AND($A1<=TODAY()+30,$A1<"") I am keeping track of employee training expiry dates. Eg. first aid certificates. So if the expiry date of an employee’s first aid certificate is within 30 days of today it will flag the cell yellow telling me that I must schedule them for retraining. The above formula works well! No problems. However, I now have about 200 entries and I want to change this formula so that it flags at 60 days not 30. But I cant figure out how to change all the effected cells at once. What would the formula be so that I could highlight all the cells and set them to 60 instead of 30 days? The above formula only works if I change each cell one at a time adjusting for each individual column and row. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating if and And | Excel Worksheet Functions | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |