Easier method to creating a link and formatting.

After setting CF on sheet1 A1

Copy that cell and select A1 on sheet2

Paste specialpaste linkOKEsc

Paste SpecialFormatsOKEsc


Gord


On Thu, 28 Aug 2008 13:05:11 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Start with A1 on sheet1

Enter a number like 3

FormatCFCell value is: between 1 and 10

Format to yellow.

Go to A1 on sheet2 and enter =sheet1!A1

FormatCFCell value is: between 1 and 10

Format to yellow.

Go to sheet1 and change A1 number to 12

Color goes away on both cells.

Change sheet1 A1 to 6 and color comes back to both cells.

There is no other way to change the fill color on sheet2 without the CF or
VBA.

Color change is not a trappable event so even with VBA it would be difficult
AFAIK and probably require Case statements based on colorindex number of
source cell.

As I said earlier..........you cannot link colors in any straightforward
manner.


Gord

On Thu, 28 Aug 2008 08:41:02 -0700, Billmc0714
wrote:

I have tried all that you suggested but none of it works I just wanted a way
so that the cell fill color change on sheet 2 when I changed it on sheet 1