I am using the below formula to highlight cells red when the last day of the month has passed - 2 months after the date occurred. I now want cells to go amber at the mid point of the month - 2 months after the date occurred and green when the date is earlier. any help would be greatly appreciated.
=TODAY()>EOMONTH(G5,2) - red
=TODAY()>EOMONTH(G5,2) - red