Basically the work sheet I am working on is a daily schedule. column A
has peoples named listed, E is a drop down menu if the person is in
work its blank but if they are on A/L or Sick you select the field.
F-AC are 30 min time slots which are coloured to which activity the
person is doing. I have a macro up and running that will count the
coloured cells to work out how many hours work there is for each
department. If someone is sick you select them from the drop down menu
and there whole line is greyed out, this is done via conditional
formatting. However, my macro is still counting the actual colour of
the cell b4 the conditional formatting took place. Is there away around
this?


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=573032