Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Conditioning Formatting Based On Due And Overdue Dates
I'm trying to set up a sheet where if a date is inputted in Cell A, it would
generate a due date in Cell B, and a date for actual completion would have to be entered in Cell C. I'm trying to set it up so that if the Cell C is blank, and it is past the due date, then the date in Cell B would be in red. Also, how do you set Cell B up to stay blank (instead of having a date with the year 1900 in it) if nothing has yet been entered in Cell A? -- Israel Rodriguez http://home.earthlink.net/~isrodriguez7/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to create an overdue message based on set dates | Excel Discussion (Misc queries) | |||
Conditioning formatting | Excel Worksheet Functions | |||
Conditioning Formatting - Thicker Borders | Excel Worksheet Functions | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) |