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
and kindred pages at this board.
Good luck.
Aladin
=========
