Excel: Conditional formatting for x number of days before

Question

I am trying to set a conditional formatting for an expiration date field. The idea is to show via color coding (green, yellow, and red) when the expiration date is approaching according to the cell (In the E column) and today's date.

It should fill green when the date in the field is equal or after today

=E3>TODAY()

It should fill yellow when the date in the field is less than today and less than 3 months (90 days) (between 89 days and yesterday)

=AND(E3<TODAY(),E3>(TODAY()-90))

It should fill red when the date in the field is less than 3 months (90 days)

=E3<=TODAY()-90

The colors do not match my date ranges.

EDIT:

I have updated my original post to include more info and updated screenshot example.

I included the dates (including "today's date") as reference. I added the conditional Formatting Rules formula in the cells. I included the Correction column to show what the correct color should be.

Answer 1

This is what I have:

And this order on the conditional formatting:

Formulae used:

Green:

=D6>=TODAY()

Yellow:

=AND(D4<TODAY(),D4>(TODAY()-90))

Red:

=D5<=TODAY()-90

Update:

With 14/03/2023

Answer 2

I changed the rule type from Use a formula to determine which cells to format to Format Cells that contain.

It worked perfectly.