filtering
 

Is it possible to filter rows based on cell formatting ?

Eg. Filter based on certain color fill .

Thanks

filtering
 

No but you could use a helper column with values bases on colour of cells of
interest then sort by helper column.
Chip has lots on colours at http://www.cpearson.com/excel/colors.htm
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
Is it possible to filter rows based on cell formatting ?

Eg. Filter based on certain color fill .

Thanks