Conditional Formatting Query

[eyelehnski]

Hi Everyone,

Is there a way where just the background color/format will be copied not the value in it? For example, in the attached file all VL are colored blue while all SL and A are colored red. What I want to happen is when I copy sheet 1 to a new sheet and change all VL to 8, the color will remain.

Thanks in advance for the assistance.

[vlady]

I think you need vba to do that. someone here could give a hand on that.
as alternative
select the data -> paste it in ms word ->then copy the data in ms word ->paste it back to excel

[eyelehnski]

Thank you vlady. I believe the vba option is more beneficial to me.

[Debraj Roy]

VBA.. Range.DisplayFormat. is a good option, however..

* Save the file as .mht file (HTML) and re-openning the file, will
save the Color formatting but loose the Conditional Formatting..

Just a mimic of vlady's trick, without using another application..

[FDibbins]

You could try Copy/Paste Special/Paste Formats

[eyelehnski]

Hi Debraj Roy,


How would I do that? Do you have a code? Apologies I am not good at vba.

[eyelehnski]

I already did that fdibbins but every time I change VL to 8, the color/format changes. What I would like to happen is even if i change the value, the format will remain.

[Debraj Roy]

* save the file as .mhl file

In Save as box, select Single web page..

19-11-2014 09-41-00.jpg


conditonal formatting.zip here is the zipped version.. forum is not allowing to upload mht file..
now you can open the same in excel.. and you can copy with "Formatting without Conditional Formatting"

[eyelehnski]

got it now. thank you all for the assistance