I have a sheet where the user would like to have rows highlighted in Red, Amber, Green based on when the last review date was completed:
Review in the last 10 months - Green
Review in last 11 months - Amber
Review in last 12 months (or more) - Red
I'm unsure the best way of doing this - do I need a formula in a helper column that I can look my conditional formatting rule up to, do I do a report that groups by months?
Any ideas greatly received on the best way to achieve getting this information.