RRico
Board Regular
- Joined
- Nov 3, 2004
- Messages
- 98
Hi everyone, have a Conditional Formatting issue when using 2 conditions below:
Condition #1: Red font when cell w/ red font is not today (past-due) [this works perfectly by itself]
=AND(I2<TODAY(),NOT(ISNUMBER(L2)))
Condition #2: Highlight background of cell when that same cell's date is today [this works perfectly by itself]
=$I2=TODAY()
Symptom: when I combine the two as depicted below... the Condition #2 cancels out/overrides Condition #1.
Know how to resolve this?
Condition #1: Red font when cell w/ red font is not today (past-due) [this works perfectly by itself]
=AND(I2<TODAY(),NOT(ISNUMBER(L2)))
Condition #2: Highlight background of cell when that same cell's date is today [this works perfectly by itself]
=$I2=TODAY()
Symptom: when I combine the two as depicted below... the Condition #2 cancels out/overrides Condition #1.
Know how to resolve this?