Doug,

It depends on how you want the formula to change.

Say that you want to compare cell A1 of Sheet1 to cell A1 of Sheet2, and so on.

If you name A1:A100 of Sheet2 TestName, and use the "formula is" CF option on cells A1:A100 of
Sheet1, with the formula

=INDEX(TestName,ROW(A1))=A1

Then you can Conditionally Format all 100 cells at once.

But, as I said, a lot depends on your workbook structure and what you are trying to achieve.

HTH,
Bernie
MS Excel MVP


"Doug Davey" wrote in message
...
Are you meaning me to try using an IS function, and is "CF" short for
conditional formatting? This sounds like it may help, but I'm not exactly
sure where you're going with this. Could you break it down a little more for
me?

The one thing I need to be able to after I get Excel to recognize the text
as a formula is to be able to copy it and have the reference change with the
copy. Will what you are recommending allow me to do that?

Thanks for the assistance - I do appreciate it!

"Bernie Deitrick" wrote:

Doug,

Give cell A1 of Sheet2 a name, for example, Name1

Then on the CF, use

Formula is

with the formula =Name1=CellAddress

like

=Name1=B3

Where B3 is the cell with the CF'ing.

HTH,
Bernie
MS Excel MVP


"Doug Davey" <Doug wrote in message
...
Is there a way to convert the text "=Sheet2!a1" into a format that will tell
Excel to use it as a reference to the worksheet?

This seems like a simple thing, but I can't figure it out...