| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If expired, change color
Hi Guys,
Using Excel 2000. I have a sheet that has dates of annual and bi-annual certificates. I would like the font color to change if the date on the sheet is expired. Can I set this up by column since some columns expire in 1 year and others in 2? The other issue is that if the certificate date is 10/15/05, the actual expiration date is at the end of the month for both 1 and 2 year renewals. Thanks, Linda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| change the color of points in 3D surface chart using VBA | Charts and Charting in Excel | |||
| background color of my cell does not change | Excel Discussion (Misc queries) | |||
| How do I change the highlight color of selected menu items? | Excel Discussion (Misc queries) | |||
| Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) | |||
Threaded Mode
