Is there anyway of alligning columns based on cell colour ?

[sloshpuppy]

Screen example.PNGHi There !

I have an excel data table, listed in column D7:D7144 are part numbers. In column E,F,G and H is a COUNTIF formula looking up the corresponding part number in the adjacent column (D) and counting the occurrence of the part number in various data tables. If the part is found, a value is added to the cell. There is a conditional format that highlights the cells orange if a value is there (typically a value of 1-50,000).

Now here's the tricky bit. I want to align the columns based on the cell colours per row?

for example: - if part number PB12345 in cell D150 has a value in E150,F150,G150 and H150 therefore the row is orange, I want to be able to sort it in the table so it appears at the top. Basically ALL the rows with a adjacent colours appear at the top sorted descending down in frequency order (all rows with the adjacent cells orange at the top followed by 3 then 2 and so on. (make sense?) see attached screen shot

Any help with this will be of a massive help !!!


Thanks Slosh x

[brokenbiscuits]

Hi Slosh

You could add an extra column with the formaula

=COUNTIF(E150:H150,">0")

And then use this column to sort high to low?

[sloshpuppy]

Excellent Biscuits !!!! Mucho Gracias.......worked a treat !

I knew it would be something as simple as this !

Much appreciated for the helping hand