Thank you so much for the help but i am still struggling,
started to work then something keeps going wrong.
Maybe if i explain what i am trying to do someone can offer a better
solution?

I am making a Crew schedule worksheet at the top in the rows going
across is the number of employees needed for that hour and each hour is
seperated by cell.
going down i just have listed crew 1, crew 2 ect. but the names will be
filled in later so i can just put 1,2,3 ect or whatever helps if a
numeric value is better.

all i am trying to do is color the cells as a line bar to show what
time the employee is working. the number of employees needed per hour
comes from a formula that matches hourly projections to crew needed per
projection... thanks to everyone's help here that parts done so i just
input the projection for the week and it gives me the correct number of
employees for each hour now i just need a bar or color or something that
ties it in to the employees??

IS this confusing enough?
I wish i could just send the sheet to view because its not as
complicated as i am making it..

any suggestions, Thanks in advance!!!


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=503516