Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting colored cells
See Bob's site
http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Ron De Bruin http://www.rondebruin.nl "James P" <James wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting colored cells
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for counting number of cells | Excel Discussion (Misc queries) | |||
Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
Counting cells with a specified frequency(how many times it appear | Excel Discussion (Misc queries) | |||
Counting Colored cells in a database | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) |