Originally Posted by
Bill
Values in worksheet A are linked to cells in worksheet B. I need to
highlight certain values in A and have the highlight link to and remain with
the value in B. If I use a background color as a way to highlight certain
cells in A, the background color does not link to B. Also, I need the
highlight in B to be associated with the linked value in B - not the cell
location in B. If the highlight in B is associated with the cell in B, when
I do a row sort in B, the highlight becomes separated from the value in B.
Another way to pose the problem is to ask how to link formatted values with
formats in A with cells in B, so that the formatting in B is associated with
the vlaue in B, not the cell in B.
--
Bill
Bookmarks