Excel 2007 tables and filters

W

Will Fleenor

Is there any way (short of VBA) to apply both a numeric filter (ex. >49.99)
and a color filter simultaneously to a row selection in an Excel 2007 table?



Thanks, Will
 
S

Shane Devenshire

Hi,

Sure, just open the filter and choose Number Filters...
then reopen the filter and choose Filter by Color
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Staggered filter on Excel 0
Advanced Filter 1
Checkbox issue - Checkbox overlapping when filter is applied 1
Calculation Time 2
Match table shading (color) to Visio color/Transparency 1
Changing row background from external program 0
Update Filter List AFTER Filter Applied 3
Filter out rows based on the value of a cell 4

Top