I have done this before and can't remember the formula or figure it out
again. I have a tabke the say is 10cells X 10 cells. In the table I want to
put the abbr. for cities such as DAL, HOU, DEN.

Now next to the chart I have 10 cells that I highlighted and named RED. In
the past I had set up a conditional formatting formula so that if the abbr
HOU in in one of the 10 cells that were calle red all of the cells in the
table that contained the abbr HOU would format its backround to red. It was a
formula that was set up as a conditional format for the 10x10 table and in
the formula it referenced the name of the group of cells that I hilighted and
renamed red. Can anyone here help me with this formula. This is the same
board where I found the formula a year or so ago but now I can't find it or
remember it

Thanks
--
Guenzak