•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting for training due dates
I am trying to format a training spreadsheet I've created for my staff to automatically flag when they are getting close to needing to retrain. We have two training cycles - some training needs to be completed yearly and some every three years. I've got the employees last training dates entered and would like the cells to highlight green if training is not due again for more than 60 days, yellow if it's due within 60 days, and red if it's due within 30 days (or overdue).
Help please!
This is how I envision it looking with the conditional formatting in place.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#conditional formatting
#training spreadsheet
#training due dates
#retrain
#training cycles