Count cells based on Conditional formatting

Hi,

I am Hoping someone can help.

I am trying to count and Sum cells accross columns based on a cell colour in a conditional format. I found this code but i have to select the colour and press run each time, i have several rows and ideally would like the answers displayed in cells (one showing the number and the other summing the values).

Please Login or Register  to view this content.

many thanks

Can you attach a sample with some dummy data?

Hi John

Please find attached my spreadsheet, thanks for looking.