View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James P
 
Posts: n/a
Default 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