I would like some help with a formula. I am using a spreadsheet to track
paid time off. I have the different kinds of time off in the cells in
different colors. For example: red=vacation; green=company holiday; blue=FMLA.

Each employee has one row.

At the end of the row, I need to take a total for each color. I need the
formula to be something like - if green, count 1, if not, zero, etc. What
would the formula be?

See

http://cpearson.com/excel/colors.htm


In article ,
"windsong" wrote:

I would like some help with a formula. I am using a spreadsheet to track
paid time off. I have the different kinds of time off in the cells in
different colors. For example: red=vacation; green=company holiday; blue=FMLA.

Each employee has one row.

At the end of the row, I need to take a total for each color. I need the
formula to be something like - if green, count 1, if not, zero, etc. What
would the formula be?