Cell shading problem

[greg7468]

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.

 

[Anne Troy]

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

 

[swatsp0p]

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.

 

[greg7468]

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.

 

[swatsp0p]

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

Next, set up Conditional Formatting in column D. Highlight cell D2 an
select Format>Conditional Formatting... enter three conditions a
such:

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

copy this format down D3nn (copy D2, highlight desired range an
Paste Special...Formats)

HTH

Bruc