. I have a spreadsheet that tracks the number of each one's Projects, and the percentage of those projects that have been completed. I have set up conditional formatting using the built in: "Format only cells that contain" and by using: "Between" and "Less Than" rules, that change color (Red, Yellow, Green), according to the percentages complete, as the year progresses and it is working perfectly.
My objective is for the colors to change each month as the year progresses. I have formulas, (based on "Today" date), in cells under each month's column, that turns from "False" to "True" automatically, when we arrive at that month, Ideas?
Solved by C. S. in 29 mins