Hi everyone,

I would like some code to automate the process of colouring th
interior of cells depending on the time entered.

I have attached a small sample so you can get a better understanding a
it is difficult to explain.

Basically here is what is required.

The time matrix is on the sheet from columns J:BF (in half hou
increments)

The time entered to start (column E), until the scheduled completio
(column F) needs to be coloured blue on the matrix.

The time from scheduled completion (column F) until max hours (colum
G) needs to be coloured yellow on the matrix.

The time entered as end of shift (column H) needs to be highlighted a
red with a "u" (diamond shape in wingdings).

Some times the tasks wrap around days (ie goes past midnight into th
next day) and this may cause extra difficulty in the code, so if nee
be I can try to alter the matrix somehow to save on this extra coding
(not sure how I would be able to achieve this and still have it in th
same format though).

There are also some blank cells in the columns (E,F,G,H). ie. betwee
different days etc.

The code would need to fire everytime a time was changed in th
columns, which in turn would mean it would first have to clear all th
matrix to clear out the old colours.


Hoping someone is able to assist

Thanks in advance
Koal

+-------------------------------------------------------------------
|Filename: tasks.zip
|Download: http://www.excelforum.com/attachment.php?postid=2696
+-------------------------------------------------------------------

--
koal
-----------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...fo&userid=1295
View this thread: http://www.excelforum.com/showthread.php?threadid=26671