Date that changes colour

Hello Fellow Bubblers!

Here I am again with probably a simple question, I’ve been experimenting trying to get a date to change after a year for our car registration system, this system is in place so the Administrator is able to inform the member of staff we need to see insurance docs to ensure they can still drive with our company as a business driver.

Does anyone know how I can achieve this? I.E. the date starts as being green, but 1 month prior to the date inputted it must turn red.

Ideally it needs to work like this spreasheet, however our administrator changes the color manually I was wondering if we could automate this in bubble?