We have policies that are due every few years. I want to automate the process as much as possible. I have columns C-T with data. I want to color cells in column T (current year) if any cells in C-T are due for review, but if the last cell with information is an A I need it to be grayed out as this policy has been inactivated. I have worked with excel, but I’m stuck.
Thank you all so much.
I have tried IF formulas, but I can’t get it right.
New contributor
Ari is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.