Avatar of lucavilla
Flag 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?
Microsoft ExcelVB Script

Avatar of undefined
Last Comment

8/22/2022 - Mon
Swapnil Nirmal


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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rob Henson

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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck