Formula to count the cells in a range that have a fill color.

G

Guest

I'm just trying to create a formula in a cell that will count the cells in a
range that don't have a "nil" fill color.
 
G

Gordon

Molly said:
I'm just trying to create a formula in a cell that will count the cells in a
range that don't have a "nil" fill color.
Click to expand...
I think you can only do that with a VB script.......
 

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

=Countif(range, criteria) 2
Excel VBA 1
Counting of cells with a specific color filled 9
Excel Macro to automatically go to the right of the last colored cell 0
Formula for identify cell format - fill colors 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to add up all cells with no fill color 9
Counting Cell Color? 2

Top