Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
170
Views
Topic starter
I have a training matrix for 8 training courses to be doen by staff every 2 years. my manager asked me to edit the expiry date and make it for 1 year. how to edit the old conditional formating ( 2 years valid date) and changed to ( 1 year valid date). I tried to change but i failed.
=TODAY()?<365 = red
=AND(TODAY()-?>=365, ?<>"")= green
Posted : 27/10/2019 7:57 am
Hi and welcome to our forum!
Please see this tutorial on Conditional Formatting using Formulas to understand what you put in your question mark placeholders. If you're still stuck after reading that, please share your Excel file so we can see where you've gone wrong.
Mynda
Posted : 27/10/2019 9:04 pm
Topic starter
Hi Mynda,
Thank you. i will try again and i will let you know.
Posted : 28/10/2019 12:48 am