LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill
 
Posts: n/a
Default Linking cells with colors or highlights

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create drop down box with the formatting of range cells colors ect Tom Excel Worksheet Functions 0 January 10th 06 09:17 PM
Linking Merged Cells C. Cunningham Excel Worksheet Functions 2 December 27th 05 09:45 PM
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 05:27 PM
How to get excel cells to change colors depending on value KV Excel Worksheet Functions 2 November 25th 04 09:50 AM
Changing Colors of Cells A-man Excel Worksheet Functions 3 November 14th 04 01:21 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"