Cell shading problem
 

Hi all,
I am hoping you can help me with the following problem.

I am trying to create an easy cycle time sheet as follows

- Col A --------------- Col b ---------- Col C --------------- Col D -

step number------Description-------Time----------
----1-------------------pick---------------2-------------"cell shaded
red"
-----------------------------------------------------------"cell shaded
red"
----2-----------------place---------------3-------------"cell shaded
blue"
-----------------------------------------------------------"cell shaded
blue"
-----------------------------------------------------------"cell shaded
blue"
----3------------------drill----------------1-------------"cell shaded
green"

Given the time I input into col C is there anyway I can shade the
corresponding row in col D and the next "x" amount of cells down
dependant on the number in col c.

This would give me a easy to read colour coded timeline in column D.

Thanks for all your help.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=380860

Perhaps this will help or get you started, Greg:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=319
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"greg7468" wrote in
message ...

Hi all,
I am hoping you can help me with the following problem.

I am trying to create an easy cycle time sheet as follows

- Col A --------------- Col b ---------- Col C --------------- Col D -

step number------Description-------Time----------
----1-------------------pick---------------2-------------"cell shaded
red"
-----------------------------------------------------------"cell shaded
red"
----2-----------------place---------------3-------------"cell shaded
blue"
-----------------------------------------------------------"cell shaded
blue"
-----------------------------------------------------------"cell shaded
blue"
----3------------------drill----------------1-------------"cell shaded
green"

Given the time I input into col C is there anyway I can shade the
corresponding row in col D and the next "x" amount of cells down
dependant on the number in col c.

This would give me a easy to read colour coded timeline in column D.

Thanks for all your help.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile:
http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=380860

Is it possible that your sheet could look like this:?

Col A --------------- Col b ---------- Col C --------------- Col D -
step number------Description-------Time----------
----1-------------------pick---------------2-------------"cell shaded
red"
--------------------------------------------*2*-------------"cell
shaded red"
----2-----------------place---------------3-------------"cell shaded
blue"
--------------------------------------------*3*--------------"cell
shaded blue"
--------------------------------------------*3*--------------"cell
shaded blue"
----3------------------drill----------------1-------------"cell shaded
green"


If so, Conditional Formatting would easily handle this task.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380860

Thank you both for your help,

Swatspop the sheet could look like that as long as the numbers
autofilled down and did not have to be put in manually.
Is it possible for the numbers to autofill down the amount of rows that
equal to the number in the cell?

Anne that solutution would be perfect, if only I could then put the
next number into row 19 and the resulting number of rows be shaded and
stacked on top of the first set.
Could this be possible?

Thanks again for your help.

Greg.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=380860

Let's assume your data begins in row 2. Enter '2' in C2. In C3 enter
'=C2'. Copy this formula down as far as you will need. Now, in the
appropriate cells, enter your '3' (in C4) or '1' (in C7) as needed
(overwriting the formula in those cells). Column C now has
2,2,3,3,3,1....

Next, set up Conditional Formatting in column D. Highlight cell D2 and
select FormatConditional Formatting... enter three conditions as
such:

Cond. 1Formula is: C2=2 and set your desired format
Cond. 2Formula is: C2=3 repeat
Cond. 3Formula is: C2=1 repeat

copy this format down D3:Dnn (copy D2, highlight desired range and
Paste Special...Formats)

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380860