Code to swap conditionally formatted cells with non-conditionally formatted cells in the same column automatically

  • Hello,


    I am trying to write a program that automatically swaps conditionally formatted cells with non-formatted cells.

    Ideally, this process would work at the click of a button and stop when no more cells in the column are conditionally formatted.

    I have had some luck swapping individual cells but have struggled running it over the entire column.


    I have attached an example spreadsheet to better explain what I am trying to accomplish.

    The left side of the sheet represents a condensed version of what I am trying to sort, and the right side represents a possible solution.


    Thank you.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!