Is there a way around using conditional formatting based on an external
reference?

What exactly do you want to do?

"hobscons" wrote:

Is there a way around using conditional formatting based on an external
reference?

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)

"Barb Reinhardt" wrote:

What exactly do you want to do?

"hobscons" wrote:

Is there a way around using conditional formatting based on an external
reference?

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.



"hobscons" wrote:

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)

"Barb Reinhardt" wrote:

What exactly do you want to do?

"hobscons" wrote:

Is there a way around using conditional formatting based on an external
reference?