Forum Discussion
Formula counting cells in a certain color
Hi! I'm making a work schedule and I'd like to have a way of counting shifts (marked as blue on the plan) for each team member.
It looks something like this:
Is there a formula for making this happen? Each row is a different person and i'd like their shifts to be counted individually.
I'm an excel noob so i'd appreciate any help!
1 Reply
Formulae work with cell values, not with cell properties like color. Thus not, you can't count with formula, using VBA only.
However, in your work schedule table I'd use any character instead of color to mark the cell (e.g. "X").
Using Conditional formatting you may add on top colors or any other formatting and by COUNTIF() formula or like to count the shifts.
