link only cells with a certain colour

L

Lena

Is it possible to select only the cells of a certain colour or cells without
a colour when I link a range of cells from one worksheet to another?
Many thanks
 
O

Otto Moehrbach

You need VBA to work directly with the colors. However, you may be able to
work with the original condition that resulted in those cells having those
colors. Post back and provide more info about what you want. Also provide
more info about the layout of your data. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
Is it possible to edit colours already saved as part of a custom theme? 0
Change colour of Field Shading in Word 365? 2
Count Interior Colour 7
Conditional format 1
How can i put text in a cell depending on colour 0
Excel Formula to colourfill cells when condition met 2
colour numbers 2

Top