Forum Discussion
Excel tracker
Hello,
I am trying to make a tracker on excel for work. The first two columns are admin data of the workers. The rest of the columns are courses that are required, yes there are a lot of them. These classes need to be done annually and what i am trying to do is to get them to populate a specific color within certain time frames from the date that is entered, so the date they recently completed a specific course. Overdue (over 365 days) is black, 365 to 335 days red, 334 to 305 days yellow, 0 to304 days green.
Example. If today is 6/21/2022, it should be green up till 304 days (4/21/2023), yellow on 5/22/2023 etc...
Any guidance is appreciated
1 Reply
I've attached a spreadsheet with rules in the Conditional Formatting dialog that accomplish what you're asking. For example
