| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Upcoming expiry date warnings that turn cell contents red
Hi
I have a spreadsheet with people's certificates (eg. CPR) with the date the cerficiate expires. I want to be able to open the spreadsheet at any time and have anyone whose certificate is one month from expiring, be red (I want the whole cell to turn red.) I've tried conditional formatting but can't seem to get it. Any help would be greately appreciated!! Thanks:) Heather -- Heather |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color change based on due date | New Users to Excel | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Threaded Mode
