Conditional Formatting using 2 conditions

[RRico]

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?

 

[Fluff]

In that case I'm not sure what is happening, as it works for me.

Fluff.xlsm
	I
1
2	13/06/2023
3	19/06/2023
4	18/06/2023
5	11/06/2023
6	12/06/2023
7
Lists

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:I11	Expression	=AND(I2<TODAY(),NOT(ISNUMBER(L2)))	text	NO
I2:I11	Expression	=ISOWEEKNUM(I2)=ISOWEEKNUM(TODAY())	text	NO

 

[Fluff]

One other thought, for the edit the 1st rule go to the Fill page page & click clear in the bottom corner.