Sounds like you have a formula in Sheet2!B1 that references the value of
Sheet1!A1, so that whatever value you enter in Sheet1!A1 is shown in
Sheet2!B1.

If this is the case, then you can use Conditional Formatting to change
the cell color of Sheet2!B2 when its value does not equal 0. Note,
howerver, that Conditional Formatting only works within the worksheet
the cell to be colored is in - that is, you can't directly use the value
of Sheet1!A1 to control the color of a cell on Sheet2.


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113088