Excel date conditions

  • Thread starter Thread starter Ania
  • Start date Start date
A

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
 
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
 
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



.
Click to expand...
 
Back
Top