Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create conditional formatting to track due dates
Help! I am trying to track dues dates. I would like to create a conditional
format so that when soemthing is due it will warn me the first time by flashing that cell in a certain color and then if it is not taken care of within so many days that date will flash in red. Can anyone tell me how to do this? Thank you for any help you can offer! Have a TERRIFIC Day! |
#2
|
|||
|
|||
The first condition in your conditional format needs to be a formula similar
to this :- =IF(AND(TODAY()-B2=0,TODAY()-B2<3),TRUE,FALSE) where B2 contains the due date. This will turn the cells the required colour if is is due or over due by up to 3 days The second condition is also a formula :- =IF(TODAY()-B2=3,TRUE,FALSE) which will highlight the cells the specified colour if it is 3 or more days over due. Hope it helps which "Soraiya" wrote: Help! I am trying to track dues dates. I would like to create a conditional format so that when soemthing is due it will warn me the first time by flashing that cell in a certain color and then if it is not taken care of within so many days that date will flash in red. Can anyone tell me how to do this? Thank you for any help you can offer! Have a TERRIFIC Day! |
#3
|
|||
|
|||
Thank you for your help Fanatik!!! It worked
"Fanatik" wrote: The first condition in your conditional format needs to be a formula similar to this :- =IF(AND(TODAY()-B2=0,TODAY()-B2<3),TRUE,FALSE) where B2 contains the due date. This will turn the cells the required colour if is is due or over due by up to 3 days The second condition is also a formula :- =IF(TODAY()-B2=3,TRUE,FALSE) which will highlight the cells the specified colour if it is 3 or more days over due. Hope it helps which "Soraiya" wrote: Help! I am trying to track dues dates. I would like to create a conditional format so that when soemthing is due it will warn me the first time by flashing that cell in a certain color and then if it is not taken care of within so many days that date will flash in red. Can anyone tell me how to do this? Thank you for any help you can offer! Have a TERRIFIC Day! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting on a PivotTable? | Charts and Charting in Excel | |||
Conditional Formatting... | Excel Discussion (Misc queries) | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Can I use conditional formatting between two sheets to track chan. | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |