| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change color of text if date is overdue
I'm trying to create a spreadsheat that will keep track of when our patients
are due for supplies. For example, they can get a certain supply every 6 months. I want the date to turn yellow when we are at the 5 month mark and red at 6 months I have a date in cell C2 and have a formula in C3 =C2+180 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating overdue date fields | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| need an overdue date to highlight | Excel Discussion (Misc queries) | |||
| Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) | |||
Threaded Mode
