Countif cell has shading

[ChrisF79]

I have a simple worksheet with rows where column A is a person's name
and then columns B through AC are different statistics. I shade
certain cells manually based on a criteria. Once those cells are
shaded, I want in column AD for there to be a countif statement that
counts the number of cells shaded on that row. It seems easy enough
but I can't figure out how to do it! If anybody could provide any
example I would greatly appreciate it.

Thanks!

 

[Dave Peterson]

It sounds like you're shading cells using format|conditional formatting.

If that's true, then the easiest way would be to use the same kind of formulas
in cells (column AD?).

Determining the color of cells based on conditional formatting is not for the
faint of heart.

If you want to look for yourself, review the code from Chip Pearson's site:
http://www.cpearson.com/excel/CFColors.htm