Calculate percentages based on cell color in column

Hello and thank you for your help in advance! I have a deadline to have this spreadsheet completed so please help!

I have put together a training tracker for my organization. I have figured out (thanks to this forum site ) how to change the cell colors based on the closeness to the expiration date.
My next goal is to have the percentages calculated and (if possible) color coated to show the percentage of people that are still valid in the separate columns E through L.

I would like <90% to have RED background in the cell, 90-99% with yello background, and 100% with green.

For example (please refer to the screenshot I have attached) in cell G73 I want to have the percentage of people whose "IA" training is still valid. I know you can't see the entire column but one person is expired (red) so the percentage would be around 99%. I want cell G73 to show 99% with a yellow background.

When calculating this percentage, ensure that it only reflects those which are valid. In other words, the "EXEMPT" cells which are gray should not be included in the calculation at all. The Green cells and yellow cells are still valid and should be included in the percentage. The red cells should be the only ones that take away from the percentage.

Thank you! let me know if this doesn't make sense.

Josh

oops, that makes sense. sorry. here you go

I see! Thank you so much. I'm barely going to make my deadline
Good job