Creating scorecard using conditional formatting

[FROGGER24]

In "b2-B40" I have cells that have background color as yellow and is a 3 point deduction for not meetin Kpi, if background color is red than 7 point deduction for not meeting Kpi. In b50 would like code to calculate score by deducting Kpi error points from 100. Thanks for help,

 

[Special-K99]

you haven;t specified what solution you want VBA or formula

However Excel cannot read the colour of a cell using a formula (unless the colour has been set by a condition - in which case just test for the same condition).
VBA can read the colour of cells

Based on your somewhat brief description I suspect VBA is your only option.

 

[FROGGER24]

Vba code is ideal

 

[Special-K99]

Unfortunately Im not expert in VBA so someone else will have to solve this.