Count If Cell Shading(Color, Pattern) Equal

G

Guest

I would like to count cells based on there shading. This shading may be forced via conditional formatting, copied from a "pattern" cell, or just manually set. I thought that ages ago you could get info on cell color/pattern (numeric value). I am probably thinking about a different tool. Have looked at CELL and INFO. Any ideas?
 
J

John Wilson

Mark,

Take a look here for some help:

http://www.cpearson.com/excel/colors.htm

John


Mark said:
I would like to count cells based on there shading. This shading may be
Click to expand...
forced via conditional formatting, copied from a "pattern" cell, or just
manually set. I thought that ages ago you could get info on cell
color/pattern (numeric value). I am probably thinking about a different
tool. Have looked at CELL and INFO. Any ideas?
 

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

Cell shading / pattern but not text 3
Count if a cell has color shading 2
Remove Pattern Without Affecting Cell Color or Gridlines 8
Sum of all cells with red shading 4
Partial Shading in Excel 2003 4
Shading cells 1
Conditional cell color. 3
VBA format of cells with colour based on IF formula 2

Top