Sorting/Filter Data

  • Thread starter Thread starter Willy
  • Start date Start date
W

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
 
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.
 
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.
 
Back
Top