Highlight row based on date and a spesific content in one cell

[sveinhelge.urdal]

I have a spreadsheet with a status column and a date column.
Status can be 1 = Finished and 2 = Outstanding
I'm looking for a way to highlight the row where the status is 2 and the date is overdue.
It looks like this:

Id	Name	Action	Status	Due Date
1​	Peter		1	10.03.2024​
2​	Alex		2	01.03.2024​
3​	Alex		2	12.02.2024​
4​	John		1	01.04.2024​

I have tried this formula; =AND($E2<TODAY();$D2="2") with no luck.

Can anyone help?

 

[ETAF]

=AND($E2<TODAY();$D2="2")
is looking for the number as text - "" changes a number value to a text value
=AND($E2<TODAY();$D2=2)
will fix that

 

[sveinhelge.urdal]

Super. That worked. Than ks.

 

[ETAF]

you are welcome