Style copy accross worksheets

timspin

Board Regular
Joined
Nov 18, 2002
Messages
231
Hi All,

I have on one work sheet traffic lights (from a drop down list you can choose either green, amber or red) - when you do the background for that cell becomes red, green or amber.

How can I reference this cell from another worksheet, and have the color change on the new worksheet - I have tried just linking it over but it doesnt work.

If the cell I want to reference is (a4) in worksheet Projects.

Any help
Thank you
Tim
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
If using condtional formatting, you can't reference the cell directly--however you can get around this if you name the cell.

So make cell A4 on the original worksheet a named range. For example, name it "Lights."

On the other sheet, you can make your conditional formatting criteria look at the value of Lights to change the colors.

Your criteria on the second sheet would be

Formula is: | Lights="Red" to color the cell red, and so on.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,499
Messages
5,596,517
Members
414,074
Latest member
Matthew Kakde

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top