Formula to detect color?
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!
|