| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting using Dates but excluding weekends
Here is my set up.
Colum E has the date a visit was done and column G is empty until a report is handed in. I would like column G to turn red when the report is not handed in within 15 days and to stay red when the date the report was finally put in to show that it was late. If there is a way to do this all your help would be mucha appreciated!!! Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS | Excel Worksheet Functions | |||
| Counting dates but excluding weekends | Excel Worksheet Functions | |||
| Formula to write Calendar dates excluding weekends - urgent pleas | Excel Discussion (Misc queries) | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
Threaded Mode
