MrExcel Publishing
Your One Stop for Excel Tips & Solutions

FILTERS


Posted by Judy T. on August 24, 2001 8:22 AM

Is there a way to filter by color when using conditional formatting?


Posted by lenze on August 24, 2001 9:38 AM

Conditional formatting is not a Cell property and it is therefore probably not possible to filter based on conditional formatting. You can, however, use the same conditions you used for formatting and use the Advanced Filter to get a Filtered list.