Excel date conditions

[Ania]

hi,

I have a spreadsheet with column: Open/Closed and column:
Due Date. If Open/Close condition is "OPEN" and Due date
already passed, then I need to have red color
representation indicating late passed due date. Any input
is appreciated! Thanks!

~Ania

 

[Frank Kabel]

Hi
lets say col. A is your open/closed condition and col. B your due date.
Try the following:
- select B1:B10
- goto 'Format - Conditional Format'
- enter the formula
=($B1<TODAY())*($A1="OPEN")
- choose a red format

 

[Guest]

THANK YOU!!!

-----Original Message-----
Hi
lets say col. A is your open/closed condition and col. B your due date.
Try the following:
- select B1:B10
- goto 'Format - Conditional Format'
- enter the formula
=($B1<TODAY())*($A1="OPEN")
- choose a red format

--
Regards
Frank Kabel
Frankfurt, Germany



.