Sorting/Filter Data

[Willy]

Hello,

We have a worksheet - 8000 rows. We highlighted some
columns in red/purple/green. Is it possible for me to
filter all Green colors [filled cells] or sort them in
order?

Regards,
Willy

 

[Poh]

Hi!

Can you elaborate base on what criteria you highlight the
columns using difference colors? Based on what condition
you would like to sort or filter these data?

These information will be helpful to solve your problem.

 

[Frank Kabel]

Hi Willy
as an addition to the answer you already received you could try the
following:
1. Insert the following UDF in a module of your workbook
public function colindex(rng as range)
colindex=rng.interior.colorindex
end function

2. Now you can use the following formula in a helper column:
=COLINDEX(A1)
copy this formula down and sort/filter with this helper column.