Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating using cells containing dates
This worked PERFECTLY for me. Thank you so much. I have one extra question...
Is it possible to make this work so that the condition chosen includes the day of AND the day after..... For example: A1 = Due Date A2 = Complettion Date (this date could be equal to or greater then the due date) Can the formula include this so that it doesn't have to be either/or? "Biff" wrote: Hi! Select cells A1 and A2. FormatConditional Formatting Formula is: =AND(A$1=TODAY(),A$2="") Select your desired style for the first condition. Click the ADD button. Condition 2 Formula is: =A$2A$1 Select your desired stye for condition 2. OK out Biff -----Original Message----- I want to have missed due dates automatically highlighted using conditional fromating. Example: A1 is due date, dd/mm/yy A2 is completion date, dd/mm/yy If A2 does not contain a value on the A1 date, I want the A1 date to turn a color. When the A2 date is entered, and the value is later than the A1 date, I want both A! and A2 to be a specific color. Any help would be appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i need help with conditional formating with dates | New Users to Excel | |||
conditional formating using dates | Excel Worksheet Functions | |||
conditional formating dates | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
conditional formating using cells containg dates | Excel Discussion (Misc queries) |