Eternally grateful if solved: % of cells with or without formatting

If you've used Condtional Formatting to set the colours then you can base a formula on the conditions that set those colours.
If you've coloured the cells manually then you will have to use VBA to detect the colours of which I'm not an expert.

You're not identifying cells which have a conditional format, you're using the same conditions that set the colour in the first place.

e.g.

In A1:A100 I want anything that contains the number 3 to be green.
Then I want the percentage of green cells in that coloumn.

Condtional Format =(A1=3) and format as green, condtional formatting formula then copied to other cells in that column.

Now I want to know the percentage of green cells.
I dont set up a formula to look at cells that are green (since you can only do that with VBA).
Instead I use the same condition that set the cells to be green in the first place since I know that any cell that contains 3 must automatically be green (assuming there are no additional manually coloured cells or other conditional formats that set the cells to green).

So in this case

=COUNTIF(A1:A100,3)/100
would give me the number of cells in column A that contain 3 which also happens to be the number of green cells.

All I've done is use the same condtion thats in the conditional formatting formula (is a cell equal to 3) to determine the number of green cells.


UPDATE: By the way, your image is tiny I havent even looked at it.
It would be better to post a spreadsheet than an image.
Posting an image means everyone has to reenter your data to provide a working solution.