Count the coloured cells

[RAMU]

Dear Friends,

I have a worksheet where a column B's cells are filled with various colours like RED, GREEN, YELLOW etc.

Now In column C, I want to count the cells which are filled in different colours.

I mean C1 will give the count of GREEN coloured cells, C2 RED, C3 YELLOW.

Is it possible ?

Pls help me.

Regards
RAMU

 

[hiker95]

RAMU,

If the colors are not displayed by conditional formatting, see:
Function CountByColor
http://www.mrexcel.com/board2/viewtopic.php?t=255872