Unfortunately XL doesn't have a way of doing what you want to do without
using macros.

Dave
--
Brevity is the soul of wit.


" wrote:

Is there anyway to detect cell color in a formula? I found the CELL
("color", ref) command, but that doesn't seem to work.

I'm interested in counting shaded cells in a specified range without
using a macro if possible.

Any ideas?

Thanks!