Using a Data Filter.

Zac · Mar 8th, 2002, 02:10 PM

I'm pretty sure I'm correct in stating "you can't use a data filter to list by colors".

Is that a correct statement?
If I'm incorrect, please instruct me.

Thanks,
Mike

Mudface · Mar 8th, 2002, 02:12 PM

You're correct, you can't. Use the search function or look back through the pages as there are many posts on this subject.

Mark W. · Mar 8th, 2002, 02:13 PM

If by "data filter" you mean AutoFilter... you can filter on text values such as "red", "green", "yellow"; but not on the colors themselves.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 02:10 PM	#1
Zac Board Regular Join Date: Feb 2002 Location: Mike Posts: 796	I'm pretty sure I'm correct in stating "you can't use a data filter to list by colors". Is that a correct statement? If I'm incorrect, please instruct me. Thanks, Mike

Mar 8th, 2002, 02:12 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You're correct, you can't. Use the search function or look back through the pages as there are many posts on this subject.

Mar 8th, 2002, 02:13 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If by "data filter" you mean AutoFilter... you can filter on text values such as "red", "green", "yellow"; but not on the colors themselves.