You can refer to a named range on another sheet.
For example, name Go!A1 as Head01 and Go!B1 as Head02
Then, in conditional formatting in the linked cell, choose Formula Is,
and enter the formula: =Head01=""
There are instructions here for naming ranges:
http://www.contextures.com/xlNames01.html
Twitty Kitty wrote:
Thank you Debra. that cleared up one question. Now all I need to figure out
is how to get conditional formatting to "accept" references to another
worksheet, or a way around that... Any Ideas?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html