Conditional formatting

[baldwin85]

I am have a spreadsheet which i am trying to use like a gantt chart (long story why the company doesn't want to use project)

Anyway, i am trying to make it so that when i add a week number to one cell it will automatically highlight and have information from another in the corresponding place on the chart.

Current week 2017 Shop floor Project No Start Wk Finish Wk Finish Yr Hrs Hrs/wk 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 OSTs PG-2xxxxx 36 51 2017 2893 181 181 181 181 181 181 181 181 181 181 181 181 181 181 181 181 181 PG-3xxxxxx 46 8 2018 576 16 16 16 16 16 16 16 16 PG-xxxxxx 4 32 2018 5766 199 PG-xxxxxx 18 34 2018 3000 176 PG-xxxxxx 10 22 2018 2500 192 PG-xxxxxx 32 46 2018 3800 253 <tbody> </tbody>

<tbody>
</tbody>

From the table above as you can see wk start 36, if i change that to 40 i want the items in wk 36 in the chart to move to wk 40... but like it would if you change the date in a gantt chart in project to would move the entire project line.

Can this be done with conditionally formatting??

i have ran out of idea and my brain hurts 1 help

 

[Special-K99]

Condtional formatting will only do that - format cells.
Cell values cannot be changed via conditional formatting.
Sounds like you need a mixture of formulas and conditional formatting

This problem looks quite complex and Im afraid I dont have much time to spend on these problems.