Fleet Registration Record

Hi and welcome to the forum

You can do this using Conditional Formatting, but you will need to define what time frame you want to apply to "about to expire" and "currently registered"

1. highlight the range you want to apply the conditional formatting to (E3:E5)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =E3<=$B$1

You would then repeat 3 & 4 with something like...
=E3<=$B$1+16
where 16 is the days before today that you want to flag - change as needed.
Make sure that the "red" rule is the 1st rule, move it up if needed

You can do this using Conditional Formatting, but you will need to define what time frame you want to apply to "about to expire" and "currently registered"

My reason for asking what sort of time frame you wanted on this, was so that I can put something together that will cater for what you want. If you want to base it on "all dates that fall in this month that have not yet passed", at the start of the month, you could have dates colored orange that are 25 days away, but then, towards the end of the month, you would have dates colored orange that might be only 5 days away?