how do I lock the fill color in a cell

G

Graham

I want to fill a cell with a colour but still be able to copy to that cell
without the fill changing. Is this possible.

Thank You
 
X

xlmate

try

Paste Special >> Under Paste in the dialog box, tick Value

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis
 
S

Simon Lloyd

Graham;220515 said:
I want to fill a cell with a colour but still be able to copy to tha
cel
without the fill changing. Is this possible

Thank YouSimply copy the cell you want right click the destination cell Past
Click to expand...
Special>Values the format of the cell will remain unchanged

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
G

Gord Dibben

If your Show Paste Options Icon is enabled, after you paste, select "Match
destination formatting"


Gord Dibben MS Excel MVP
 

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

Function for summing or counting cells based on a specified fill color 3
Fill tringle in a cell with color 1
Photo rotation within a shape - Microsoft 2013 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Conditional Formatting based on cell text 3
Fill Lock! 1
how do I lock the fill color in a cell 1
Locking cells 3

Top