View Single Post
  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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