ExcelBanter - Sorting data by Cell Colour

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sorting data by Cell Colour (https://www.excelbanter.com/excel-programming/308739-sorting-data-cell-colour.html)

Andy Chan

Sorting data by Cell Colour

I have a column of data , some highlighted in green, some
highlighted in red.

i want to filter the data to only show those in green. How
do i do it ?

Regards,
Andy

Frank Kabel

Sorting data by Cell Colour

Hi
see:
http://www.cpearson.com/excel/SortByColor.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Andy Chan" schrieb im Newsbeitrag
...
I have a column of data , some highlighted in green, some
highlighted in red.

i want to filter the data to only show those in green. How
do i do it ?

Regards,
Andy

All times are GMT +1. The time now is 07:31 AM.