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

==========