The document I am working on at the moment consists of 11 sheets. 10 of which are results and the 11th is total results. What I am having trouble with is conditional formatting a cell on the total results sheet.

I am concentrating on cell G10 on each of the 10 sheets of results. Each cell will either have 'Yes' or 'No' and I would like to count the number of 'Yes' so that it will give me a % and if it is 100% the cell will turn green, anything lower it will turn red.

Hope you can help, many thanks!!!