How do I count rows highlighted with color fill?
Posted by Charlie on July 11, 2000 11:14 AM
I am working on a large project that contains over 20000 entries (rows), 14 columns. Each row has unique info pertaining a comm system program.
Now every time I check each one for status, I use color fill across the row to identify the action taken:
RED - Deactivated
GREEN - Active
LIME - Pending
YELLOW - Re-check status
No Fill - Not yet checked
I thought I could set up 5 independent cells with formulas to count the color filled cells as I went along, but I cannot figure out how to include the color fill as an argument within a formula.
Any help is appreciated!! :)