Datafilterautofilter, custom and contains blue

--
Regards,

Peo Sjoblom

(No private emails please)


"Rodney" wrote in message
...
employing excel as a db
cells in 1 column may hold ,

"blue,white,orange, red"
"black,blue,white,orange"
"peat brown, raspeberry red,blue,white"
"blue,puce, vermillion, bistre,white,orange, red"

Is there a way I can ask excel to return all
records that hold "blue" and auto hide the rest?
Or sort so all records with blue in cells in that column
go to the top?



Send spam to the FTC at


.