VBA code to copy entire row IF a specific word is in a SPECIFIC column

  • Hmm..i see. I dunno why i keep getting these errors when i insert the macros. Maybe it is smth with my excel.


    1. Do not confuse Macros with Formulas ... In this particular case, you are dealing with Conditional Formatting ... so you are using Formulas ...


    2. What is smth ...???


    3. Will add the Formula to your latest test file ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • 1. Yes, you are right. I know Conditional Formatting is different than Macro's. I was using conditional formatting to enter your "formula" but i am getting error.
    2. Smth = something (abbreviation)
    3. Thanks again!

  • Thanks for your Thanks AND for the Like :smile:


    P.S. J9 cell will turn red on Friday

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)