• 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.

Conditional formating in VBA

lesley burlingham

lesley burlingham

Member
Hi

i would like to strikethrough a cell if the answer to a question is 4 or 6 or 9 etc. Is this possible in VBA. I have to many conditions to use conditional formatting.
 
Hi,

Do you need a shortcut key to do that or some thing else. I recorded a macro to do that with a shortcut key.
 
Hi,
You can also apply conditional formatting without VBA:
=IF(OR(A1=4,A1=6,A1=9),1,0)

Cell format > Font > Mark Strikethrough

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