garywr Wrote:
I am trying to change the cell shading based on the value in a cell on
another worksheet of the same workbook.

Reference the cell in the other worksheet in a new cell in the current
worksheet, then use Conditinal Format to check the value in the new
cell.
Ilan


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=466472