Calculating percentage of Shaded Cells in a row

[BrettPotts]

I am trying to calculate the number of shaded cells v's none shaded cells in
a row. There is no data in the cells only black shaded cells or uncoloured
cells.

 

[Gary''s Student]

see:

http://www.cpearson.com/excel/colors.aspx