ExcelBanter - How to select certains records meeting a certain condition !!!!

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to select certains records meeting a certain condition !!!! (https://www.excelbanter.com/excel-worksheet-functions/121064-re-how-select-certains-records-meeting-certain-condition.html)

How to select certains records meeting a certain condition !!!!

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