B
bitsnpieces
I am setting up a vacation schedule in Excel. I have a line of 31
squares, one for each day of a standard month, each square occupying a
cell in a column. If someone is on vacation, the square will be red
and I plan to insert, say, "8" in the square portraying the number of
vacation hours for that day. I also plan to use this same line of 31
squares to track personal days off and in that case each personal day
would be denoted by a blue square with the number "8" in it.
At the end of the line of 31 squares, I want to have columns with
automatic formulas in them to automatically total the number of hours
in each red square and total the number of hours in each blue square.
There are going to be about six different color options for the
squares and each will need to be totalled in its own column at the
end.
What sort of formula can I use that will be able to read the color of
the squares? This will be quite an involved formula, I'm sure, so I
would appreciate an example.
Many thanks.
squares, one for each day of a standard month, each square occupying a
cell in a column. If someone is on vacation, the square will be red
and I plan to insert, say, "8" in the square portraying the number of
vacation hours for that day. I also plan to use this same line of 31
squares to track personal days off and in that case each personal day
would be denoted by a blue square with the number "8" in it.
At the end of the line of 31 squares, I want to have columns with
automatic formulas in them to automatically total the number of hours
in each red square and total the number of hours in each blue square.
There are going to be about six different color options for the
squares and each will need to be totalled in its own column at the
end.
What sort of formula can I use that will be able to read the color of
the squares? This will be quite an involved formula, I'm sure, so I
would appreciate an example.
Many thanks.