Lock Conditional Formatting Solved

Question

Hello,
in Excel 2010 I would like to freeze the result of my conditional formatting (it's colors) so I can sort afterwards
currently when I sort my colors change because my conditions are linked to another sheet
thank you

Configuration: Windows 7 / Internet Explorer 8.0

Geniux · Accepted Answer

Hello,
I'm a bit late, but I found the post today,
Under Office 2007
Select the desired cells and copy them into Word.
Select all in Word, and copy them into a new Excel sheet.
The format is applied correctly without conditional formatting......

Raymond PENTIER · Answer

Strictly impossible.  -- Retirement is great! Especially in the Caribbean... :-) &#9787; Raymond &#9794;

Mike-31 · Answer

Hi,

Absolutely, we can write a VBA code that colors the cells based on criteria, but it's no longer conditional formatting.
If you have some knowledge of VBA and if you provide precise explanations, we can try to write a code.

--
See you later
Mike-31

A time of failure is the perfect moment to sow the seeds of knowledge.

speirani · Answer

To be honest, I would like the formatting to follow the line even after a sort thank you

speirani · Answer

Example: I have conditional formatting for cells B1..C3, I sort my rows 1, 2, 3, my row 1 ends up in row 3 but with the conditional formatting criteria of row 3 before the sort
I would like the conditional formatting to follow the cells as the sort
Best regards

Lock Conditional Formatting

5 answers

More details

Canon mg5150 printer installation on windows 11

How to install a hard drive on my wi-fi router

My pc boots into bios with windows 11

No tone on my redmi note 13 pro 5g

Trojan horse

Vba macro repeat action until end of document

Message about "new ways to communicate"

Problem with directx 12 - steam game launch

Rakuten plans to close its operations in france by the end of 2026