View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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