If cell A7, which is a future-date in date format and fill-colored green, reaches 30 days away from todays date change fill-color to orange and 7 days away change to color red. Is there a way to only change the dates that are green-colored dates and not non-green-filled dates also approaching 30 / 7 dates simultaneously.
Bookmarks