Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formating
I have 4 cells. Below is what I am trying to accomplish. I need the formulas
for each of the conditions. Please help. Condition for Cells 1-3 Condition 1: If date is greater than NOW() - Red Condition 2: If date is less than NOW() - Green Condition 3: If there is a date in cell 4 (over ride conditions 1 and 2) - Blue Condition for Cell 4 Condition 1: If there is a date in cell 4 - Blue Thank you, Aviator |
#2
|
|||
|
|||
Assume the cells ar A1:A4, select A1:A3 with A1 as the active cell,
formatconditional formatting formula is, for the first condition use =ISNUMBER($A$4) format button and select blue patterns/fonts, click OK and click add, condition 2 =AND(ISNUMBER(A1),A1TODAY()) format button and select red patterns/fonts, click OK and click add, condition 3 =AND(ISNUMBER(A1),A1<=TODAY()) format button and select green patterns/fonts, click OK twice select A4 and use the same as condition 1 =ISNUMBER($A$4) there is no good way of knowing that a cell holds a date so isnumber is the closest you can get Regards, Peo Sjoblom "Aviator" wrote: I have 4 cells. Below is what I am trying to accomplish. I need the formulas for each of the conditions. Please help. Condition for Cells 1-3 Condition 1: If date is greater than NOW() - Red Condition 2: If date is less than NOW() - Green Condition 3: If there is a date in cell 4 (over ride conditions 1 and 2) - Blue Condition for Cell 4 Condition 1: If there is a date in cell 4 - Blue Thank you, Aviator |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating? | Excel Discussion (Misc queries) | |||
Can i carry out more than 3 conditional formating Queries? how? | Excel Discussion (Misc queries) | |||
How to change an entire row using conditional formating | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS. | Excel Discussion (Misc queries) |