Lock Conditional Formatting

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.

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

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

Strictly impossible.

--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂