PDA

View Full Version : [SOLVED] Data sort a dynamic range of conditionally formatted cells?



roxnoxsox
03-15-2016, 02:37 AM
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
03-15-2016, 03:13 AM
Add a helper column with a formula that emulates the CF, and sort by that.

roxnoxsox
03-15-2016, 03:22 AM
Hi xld,

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

roxnoxsox
03-15-2016, 04:27 AM
I've figured out how to do this now, thanks! :)