H
hobscons
Is there a way around using conditional formatting based on an external
reference?
reference?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Barb Reinhardt
What exactly do you want to do?
H
hobscons
I want a cell in one worksheet to change color based on what is in a cell in
another worksheet. (Conditional formatting based on an external reference,
but you can't do that in Excel)
another worksheet. (Conditional formatting based on an external reference,
but you can't do that in Excel)
B
Barb Reinhardt
I'm going to assume that you have one cell on the other worksheet that you
want to use for your conditional format. Go to that cell and do this:
Insert -> Name -> Define and give it a name that makes sense.
On the cell or cells that you want to compare to the first cell, put a
formula like this in the conditional format.
Formula =$A$1=TEST
You may have to remove some $ to get it to work for all cells.
want to use for your conditional format. Go to that cell and do this:
Insert -> Name -> Define and give it a name that makes sense.
On the cell or cells that you want to compare to the first cell, put a
formula like this in the conditional format.
Formula =$A$1=TEST
You may have to remove some $ to get it to work for all cells.