This may help.........

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

Vaya con Dios,
Chuck, CABGx3



"sandeep" wrote:

Dear Members,

I have a table which has 2 columns and 10 rows. The 1st,5th,7th,9th rows are
coloured( AS per certain criteria) . I want to select those rows which are
coloured, how can i do that ??

I general how to select rows which meet a certain condition like one example
mentioned above??? Is ther any function in excel for this . Please give your
comments.

thanks
regards
sandeep