I have been scratching my head and searching the internet for the past 3 hours on how exactly to achieve what I want! I'm almost tempted to do this by hand but I want to automate it if possible!
I've created a spreadsheet for all the domains under our control and I want the date to go orange if it's due for renewal in the next 3 months, green if it's anything further in the future.
Here's a snapshot of what I've got so far. Please disrgard any colour/formatting visible. I've stripped the domains for confidentiality reasons but the first two columns are currently fully populated. I'd like the entire row to be formatted with the colouring as it shows currently.