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.

I have an excel sheet with several columns. Column b contains dates – several rows could contain the same date. Column c contains a series of values for each date (30, 20, 45, etc).