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.