Any way to keep the highlights from conditional formatting when you copy paste in value?

[Ninad7]

Hello guys!
I have this table were, all the values come from vlookup but the value that are in red are manually input. So I have used conditional formatting =NOT(ISFORMULA(K8)).
*

I want to copy this table to other sheet but I want to copy in value and also want the highlight with it.
Whenever I copy it normally and then select the values only and copy it in value all the cell turn red because of conditional formatting.
Any way to keep the highlights from conditional formatting when you copy paste in value?


*This is just an example. Real data is very huge.

 

[Joe4]

Your Condition Formatting is dependent upon whether the cell is a formula or not.
So, when you do a Copy -> Paste Special Values, you are removing the formula, which would then change your Conditional Formatting result from FALSE to TRUE and color the cells.
By using Copy -> Paste Special Values, you are changing the conditions that the Conditional Formatting is looking at!
So you either need to NOT use Copy -> Paste Special Values, or change your Conditional Formatting Rules.

I am afraid what you are trying to do does not appear to make much sense.
But if you really want to do something like this, you may want to have a look here:

convert conditional formatting into standard one

hello guys i feel this board is tyhe last resort for this question - is anyone aware of any add-in that could do this many many many many thankyou's for help this relates to ms excel 2003 only alex

www.mrexcel.com

or here:

Converting Conditional Formatting to Regular Formatting

Conditional formatting allows you to change how information is displayed based on rules you define. What if you want to remove those rules, however, and keep the formatting intact? This tip addresses the issue.

excelribbon.tips.net