Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create drop down box with the formatting of range cells colors ect | Excel Worksheet Functions | |||
Linking Merged Cells | Excel Worksheet Functions | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
Changing Colors of Cells | Excel Worksheet Functions |