VBA Problem. Trying to SUMIF the cell is a certain colour

**Ladyanna** · 12-02-2009, 10:16 AM

Annual Leave Planner 2010.xlsmHello Everyone,
I desperately need some help with an excel sheet used to counting annual holidays and sickness. I have never used VBA before and whatever I have done is not working at all.
I have attached my sheet and I hope somebody will be able to help me.

Use the top 5 as an example (Rows 4-8)
In the red Column, I would like it to SUMIF the cells along the rest of the row are red.
In the green Colum, I would like it to SUMIF the cells along the rest of the row green,
I hope this makes sense. Red stands for holiday and green for sick. I just want totals of the amount of sick and holidays each person has taken.

Perhaps my F-Column is messing things up. It is supposed to be C+D-E if that makes sense. Sorry, I am pretty Clueless

Is there an easier way to do this? Or can someone help me please.

Thank-you very very much

**NBVC** · 12-02-2009, 02:07 PM

It works for me..

What is the problem you are getting?

**Astroboy142** · 12-03-2009, 12:57 AM

Do you actually color in your cells red or green yourself? If you do, you could automate your spreadsheet so that you input a letter (say "L" for leave and "S" for sick). Once you enter in your letter you could use conditional formats so that the cell automatically turns red or green, depending on the letter it finds.