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?
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?