I am trying to conditional format on an entire column with 4 separate outcomes as colors.
With a given date (Jan 1st 2015 for example) when the "Today" from the computer's clock reaches within 90-61 days / 60-31 days / 30-1 days / and 0-negative days to each create a separate color. I am currently on top of assignment of the effect, I need help with deciding which of the rules to choose, and what the formula to enter is.
Following on, I need to add each of the different instances in real-time, as they change together, and would like some help on how to write the formulas for each cell designated for 3 months out, 2 months out, 1 month out, and expired.
Date format is yyyy/mm/dd
If the responder has the time to explain the parts of the formulas, and what they pertain to so that I can learn the why and how as well, I would appreciate it. It empowers me to help pass knowledge along to the next guy I meet in person, outside of a forum.
Bookmarks