Apply a condition after the due date
Posted by Rick on February 04, 2002 3:22 PM
Help, I have a 2 columns: date expected and date received. I want to put a condition on the date received column that the cell will turn red if its past the expected date. I also want the red to go away after the date is deleted from the date expected.
Any help would be greatly appreciated!
Posted by Aladin Akyurek on February 04, 2002 3:41 PM
Select the cells of two columns with dates.
Lets say that A2:A100 houses the date received values and B2:B100 the expected dates.
Activate Format|Conditional Formatting.
Choose "Formula Is" for Condition 1.
Enter as formula in the empty box:
=A2>B2 [ Note. No $-symbols ]
Activate Format.
Choose the color on the Patterns Tab.
Click OK, OK.
=========
Posted by Richard S on February 04, 2002 4:27 PM
Aladin,
If Rick wants the red to go away when the expected date is deleted, shouldn't the formula be
=IF(B2>0,A2>B2,0)
Richard
Posted by Aladin Akyurek on February 04, 2002 4:48 PM
Yep. Did not pay attention to deleting I guess. How about a boolean setup:
=(B2>0)*(A2>B2)>0
Cond Formatting should be applied to only column A (this, in view of what I said in my first post).
Thanks for pointing out the trouble.
Aladin
==========
