View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Boll Weevil Boll Weevil is offline
external usenet poster
 
Posts: 1
Default Linking cells by cell text.......................TIA

Hi,

On sheet one, I have a large table with unique 4 digit hexidecimal values in
each cell.

On sheet two, I have uniquely colored columns of cells of hexidecimal values.
The same values picked from

What I want to happen is to have get the cells automatically assign themselves a
color from the color group they are assigned to from sheet two. So, if I type
04AC in the red column in sheet 2. The corresponding 04AC cell in sheet one
would turn red.

Thanx all for any help.