hi
yes. in cell B1, sheet2 enter =sheet1!A1
then use conditional formating on cell B1, sheet2.
on the menu bar...formatconditonal format
cell value is....... equal to.......1..............pick you format.

regards
FSt1

"VROSARIO7" wrote:

Hi,

I am having trouble with the following:

What I want to be able to do is change the color of cell B1 on sheet 2 once
the data on cell A1 sheet 1 is entered.

So if I entered 100% in A1 sheet 1, i want the color of B1 sheet 2 (which
also says 100%) to automatically change.

Is this possible?