counting colored cells

I am working on a scheduling program. I want to use color in the cells
representing the hour and continue the color through the duration of the day
for example if an employee comes in at 9am and leaves at 5pm I wanted to
color the cells from 9-5. With that I wanted to count for a total the number
of cells colored so I may end up with a total hours used for the day with all
employees

See Bob's site
http://www.xldynamic.com/source/xld.ColourCounter.html

--
Regards Ron De Bruin
http://www.rondebruin.nl



"James P" <James P@discussions.microsoft.com> wrote in message news:002B872E-C431-472C-AEC0-90BB125B8FC8@microsoft.com...
>I am working on a scheduling program. I want to use color in the cells
> representing the hour and continue the color through the duration of the day
> for example if an employee comes in at 9am and leaves at 5pm I wanted to
> color the cells from 9-5. With that I wanted to count for a total the number
> of cells colored so I may end up with a total hours used for the day with all
> employees

This might be what you are looking for.

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm


"James P" wrote:

> I am working on a scheduling program. I want to use color in the cells
> representing the hour and continue the color through the duration of the day
> for example if an employee comes in at 9am and leaves at 5pm I wanted to
> color the cells from 9-5. With that I wanted to count for a total the number
> of cells colored so I may end up with a total hours used for the day with all
> employees