Percentage calculation based on color in a training matrix

Hi All,

Please find the attached file..

I need a conditional formatting for the mandatory courses with the condition as following,

such as for a driver IND,H2S,IR,DR,DOD1,DOD2 is the mandatory courses,so if a date value is not present in the cell against a driver
for the particular courses then the color of the cell should change as you can see in the sample file..

similar case for Lv-driver, DOD2 is not mandatory hence there is no color change..
Supervisor,(IND,H2S,IR,DR,RB) is mandatory but he haven't completed so there is a color


Now the second part is getting the percentage based on the colour,i dont know if it is possible or not..
N9:O23 i would like to get the numbers based on the colour and E2:E5 i like to have percentage values..

Hope all understood my query..

Any help..

Thanks,
Ak