Microsoft Excel Help

[BoilerUp1]

Hi,

I am working on a project for work. I am pretty proficient when it comes to Microsoft Excel, but am having a little trouble with this certain task. What I would like to do is create a pricing model that reflects the change of a raw material all the way to a finished good. What I would like to do is make it so that when I change a raw material price, make it so that all of the affected finished goods become highlighted or change to a different color. I have experimented with the conditional formatting options but haven't seemed to have any luck. Any suggestions?

Thanks in advance

[BurgundyClone]

If nobody replies, try MrExcel.com -lot of good people there

Hi,

I am working on a project for work. I am pretty proficient when it comes to Microsoft Excel, but am having a little trouble with this certain task. What I would like to do is create a pricing model that reflects the change of a raw material all the way to a finished good. What I would like to do is make it so that when I change a raw material price, make it so that all of the affected finished goods become highlighted or change to a different color. I have experimented with the conditional formatting options but haven't seemed to have any luck. Any suggestions?

Thanks in advance