• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hiding rows based on formatting

P

Phuzzy

New Member
I would like a macro that would hide a row if a specific cell on that row contained text that was formatted with a Strikethrough.


So, if cell A25 had text that was formatted with strikethrough, row 25 would get hidden. The range for strikethroughs is A2:A1000.


Thanks,
 
Hi, Phuzzy!


Should this be helpful?

http://chandoo.org/forums/topic/need-formula-to-hide-row-based-on-cell-value


You'll have to change the test condition to "Selection.Font.Strikethrough = True" (unquoted), after selecting each cell in range.


If you can't manage to handle it or any issue arises, just advise.


Regards!
 
You must log in or register to reply here.
Back
Top