Highlight cells based on date AND cell value

Question

I am stuck on a formula for the conditional cell formatting. I want to highlight cells based on "AND" rule of these two conditions:

• In cell H3 I have % values. I want to highlight cell where value is below 90%.

AND

• In cell B3 I have date formatted as MM/DD/YYYY. I want to highlight cell when the current date is one day before compared date in B3.

I tried:

=AND(H3<90,B3 < TODAY()-1) 

What I am doing wrong?

Here is an example.

Answer 1

Works fine and as intended. However this might be the formula you're looking for:

  =AND(H3<90,(B3-1) <=TODAY())