You can use Conditional Formatting, you just have to Name the cell you
want it to refer to. Say in Sheet1!A1, you want to apply the shading
if Sheet2!A1 = something. Go to InsertNameDefine. Type in a name
for the reference to Sheet!2A1 ( I used Shade). Go to the cell you
want to apply the CF to. Change the Cell Value is: option to Formula
is then use something like:

=Shade<""

Click FormatPatterns and pick the color you want. Click OK and OK.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544350