Hi all...second try here...
I have numberous cells that are colored in to reflect whether the number in the cell is negative (red) or positive (green). Some of these cells are conditionally formatted to automatically color themselves in, while others I color in manually.
Question: is there a way excel can count the number of cells colored in with a certain color so I can get a percentage/ratio of red cells to green cells? Thanks!
- John
CROSSPOST NOTE: this post also appears at the link below:
http://www.ozgrid.com/forum/showthread.php?t=82528
Bookmarks