| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If data in one column, take date, add 2 days, and turn the entire column a color...
I have two columns setup... Column A would have a received date and
Column E would have a name. What I'm looking to do is if there is a name filled in in Column E (any data at all), then take Column A and add two days. If it's past due (example: Column A has 8/01/06, today is 8/22/06, so it would be past due), then turn the entire row a selected color. Is this possible? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| Dynamic column chart - auto sort on data range | Charts and Charting in Excel | |||
| Need a formula that will turn a date red if that over 60 days | Excel Worksheet Functions | |||
| Conditional formatting based on a date + 30 days | Excel Discussion (Misc queries) | |||
Threaded Mode
