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 |
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 |
All times are GMT +1. The time now is 03:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com