I need to shade a cell on one sheet depending on how a formula returns in
another worksheet. Excel tells me I can't do that. In this forum, I found
advice to simply name the range and I've tried that, but still can't get my
formula to work correctly.

Help from anyone would be appreciated.

Hi,

A look at your formula would have been helpful but in general it works like
this. name a range on a workshee and refer to that name from another
worksheet. For example in the case sh2 is a name ranhe on Sheet2 and this
conditional format on sheet1

=sh2<""

changes the cell colour when sh2 is populated.

Mike

"jfcannon" wrote:

I need to shade a cell on one sheet depending on how a formula returns in
another worksheet. Excel tells me I can't do that. In this forum, I found
advice to simply name the range and I've tried that, but still can't get my
formula to work correctly.

Help from anyone would be appreciated.