MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding colored cells


Posted by Waynef on August 30, 2001 6:49 AM

Hi,

I am making an Excel document of a yearly planner. On my rows i have job types and in columns i have the days of the year. The i have just highlighted cells to the same color as the jobe types. Now i would like to count all the different colors to know high many days i was doing what for. I have searched your message board (even old 1). I did find some modules that i thought would work but didn't. Can you help me out ?


Posted by Aladin Akyurek on August 30, 2001 7:01 AM

You have something like this:

Column A

Job1
Job2
Job1
Job3
Job3

Column B

date1
date2
date3
date4
date5

and you want a count per job type, say in C, like:

Job1 2
Job2 1
Job3 2

And you colored per job type (e.g., cells with Job1 green, etc either manually or using conditional formatting).

Am I on the right track?

Aladin

==========

Posted by Waynef on August 30, 2001 7:09 AM

You are close,

Column A has unique data in each row.. ie..
Service (highlighted yellow)
Contract (highlighted blue)
Office (highlighted red)
etc... (highlighted Green)

Across the row 1 I have set all the dates of the year.

Then for my planning I just highlight the kind of work i did on that day.

Now i want to add how many days i did service ect by the colours I have highlighted.

Thanks for your time,


Posted by Aladin Akyurek on August 30, 2001 8:08 AM

The task requires VBA code though.
Have a look at the tread

28547.html

and kindred pages at this board.

Good luck.

Aladin

=========