count colored cells

O

One-Leg

In cells A1 to A5, I have the following FILL COLOR assigned to each cell:

A1: Default white fill color
A2: Blue fill color
A3: Default white fill color
A4: Red fill color
A5: Default white fill color

In cell A6, I wanna be able to know how many cells are not white.

Thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to format cells -fill color 2
Function for summing or counting cells based on a specified fill color 3
Creating Labels Over 3-Up Image 2
Remove Hyperlinks Without Changing background shading 14
Change Color of cell 3
Can RGB fill color be automated based on 3 cell values? 2
Excel Macro Help 1
Dynamic pointing to a cell 0

Top