Count cells based on Conditional formatting

[michelle 1]

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

[JOHN H. DAVIS]

Can you attach a sample with some dummy data?

[michelle 1]

Hi John

Please find attached my spreadsheet, thanks for looking.