Counting cells with colours

[ianwuk]

Hello.

I need help counting cells that contain colours using a formula.

I have data that looks like this:

How can I count green cells in both columns B and C and display the total in cell B7? (so it should be 1).

How can I count the green or orange cells in column B and put the total in A7 (so it should be 2).

Many thanks.

 

[Yongle]

Re: Need help counting cells with colours

If cells coloured via conditional formatting then use the same condition to build your formula in the cell to give the correct value

If the cells are manually formatted then VBA is required

 

[ianwuk]

Re: Need help counting cells with colours

If cells coloured via conditional formatting then use the same condition to build your formula in the cell to give the correct value

If the cells are manually formatted then VBA is required

Thanks for replying. I managed to get it working using VBA.