Conditional Formatting across worksheets
 

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.

Conditional Formatting across worksheets
 

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.