How do I set up formatting to highlight when a value is used x number of
days in a row on a schedule?

For example I have Bob, Ron, Jan and Max working for me. My schedule
looks something like this:

Mon Tue Wen Tru Fri
Bob Ron Bob Bob Bob
Jan --- Jan Max Jan
Ron --- Max Ron Max
--- --- Ron --- ---


Is there a way so that any time anyone is scheduled three days in a row
they are Highlighted in yellow and if they are 4 days in a row they are
highlighted red?

Also, how can this be accomplished when other formatting is included as
well?
i.e. Bob is always highlighted in blue, Jan in green, Max in brown and
Ron in black, so the chart would look something like this:


Mon Tue Wen Tru Fri
Bob Ron Bob Bob Bob
Jan --- Jan Max Jan
Ron --- Max Ron Max
--- --- Ron --- ---


--
rbmcc
------------------------------------------------------------------------
rbmcc's Profile: http://www.excelforum.com/member.php...o&userid=30602
View this thread: http://www.excelforum.com/showthread...hreadid=502547