Link to home
Start Free TrialLog in
Avatar of lucavilla
lucavillaFlag for Italy

asked on

Excel VBA > show only lines that match conditional formatting

In Excel 2007, I used conditional formatting to color in red the font of the lines that match a custom formula.

How can I set a filter in VBA that show only the lines that were conditional formatted?
Avatar of Swapnil Nirmal
Swapnil Nirmal
Flag of India image

Avatar of lucavilla


n_swapnil: it filters by font color so it's an indirect method.
Is there a direct method that filters by applied condition?
Avatar of Rgonzo1971

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Assuming your Conditional formatting is formula driven, replicate the formula in a spare column.

If replicated correctly, the result in the column will be TRUE or FALSE. You can then filter on that column.

Rob H