Daily Schedule

Coloumn A is a list of names
Coloumn E is a drop down menu with the options of blank, Sick and AL
Coloumns F-AC are 30min time cells

I have a colour counting macro so what ever colour i change a sell to
will count it as 0.5. I have an update button i press to calculate the
hours once i have put in all the different colours. However if i select
the Sick or AL drop down menu after i've done the colours it greys out
the whole line as i want, but if i update again its still counting the
colours that were should before, i guess this has something to do with
the conditional formating. Is it possible get a macro to delete the
data and cell colour so this doesn't happen?

I have attached my spreedsheet so you can see what i mean


+-------------------------------------------------------------------+
|Filename: MASTER 2006.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5246 |
+-------------------------------------------------------------------+

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