Data sort a dynamic range of conditionally formatted cells?

[roxnoxsox]

I understand if this isn't possible to do but I thought there would be no harm in asking, if anyone IS able to help!


I have a selection of data in columns A to L. The number of columns stays the same but the number of rows will change every day. I have 1 row at the top containing headers.

I want to write a macro to data sort based on the conditionally formatted cells in column J. The manual 'data sort' looks like this:
Sort by: Column J: Cell Color: Red: On Bottom
Then by: Column J: Cell Color: Green: On Top
Then by: Column J: Cell Color: Yellow: On Top
Then by: Column J: Cell color: Orange: On Top


Anyone know if this is possible?

[Bob Phillips]

Add a helper column with a formula that emulates the CF, and sort by that.

[roxnoxsox]

Hi xld,

Sorry not sure what you mean by this, how do I do this?

[roxnoxsox]

I've figured out how to do this now, thanks!