Count Cell with Background color

[rizmomin]

HellO:

Please refer to attached sheet.

I need a VB Macro or formula which will perform the following:

I have weekly color coded schedule.
For a particular date in column C:I, i need the AM Count,Mid Count and PM Count

Each cell is colored for AM,Mid and PM shift.
I need the count for each shift in Cell C4:I6, based on color in cell C7:I29

Please let me know if any questions.

Thank you

Riz Momin

[rizmomin]

Hello;

Can any one help with this one.

Thank you

[LaffyAffy13]

What classifes something as AM, Mid, and PM?

[gjcase]

Riz:

While you can count colors using the Range.Interior property, that won't work if you are coloring cells via conditional formatting.

Suggest you just include a CountIf function in C4: I6 to count the number of cells meeting the cirteria you are using to set teh conditional formatting. Then no macro is required.

[rizmomin]

Hi gjcase:

I am using conditional formatting to color the cell.
So please help me with the Countif functions.

Thank you

Riz Momin

[Leith Ross]

Hello Riz,

I have added a few SUMPRODUCT formulas in cells C4:I6 to count the colored cells. It does not really count the colors, it checks that the cells contain the times you specified in your conditional formatting rules.

[rizmomin]

Hi Leith:

This will work great for me.
Thank you so much for your great hep.

Riz Momin