I want to count cell by color.
Me and my back to working rotations and I have a excel sheet for the whole year working days marked in different color. I want to count how many days we worked (marked) counting by color. I need a simple countif formula, if possible.
Regular excel formulas cannot count color. Color is formatting, not dataI need a simple countif formula, if possible
Having said that, is there some logic to how the colors were applied? perhaps we can base the count off that, and not the color?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, I understand now.Originally Posted by FDibbins
Regular excel formulas cannot count color. Color is formatting, not data
Having said that, is there some logic to how the colors were applied? perhaps we can base the count off that, and not the color?
Thanks for the reply.
Regards,
Ravi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks