You can set the CF on Sheet1 based on what is in a cell on Sheet1.

Why do you need to reference Sheet2 in your CF condition?

Assume A1 in Sheet1 has a linking formula to A1 in Sheet2

=Sheet2!A1

CF on the value returned by that formula.

If not the case, please show us the CF condition formula.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:05:01 -0700, AT wrote:

Hi, I currently have a lot of data on sheet 2, linking the content to sheet 1
for easy reference. I wish to to use conditional formatting on sheet 1 with
the original data remaining in sheet 2. Unfortunately, when i try to link the
cell through the application of conditional formatting, once I click ok, it
states that you cannot do this because the linked cell is on another sheet.

The easiest solution is probably to duplicate the appropriate cells on sheet
2 to sheet 1 with links, but I dont particularly want to duplicate data to
avoid confusion.

So, to put it simply, is there an easy solution to this simple problem?

Thanks in advance