Any one can help me to correct below VBA

  • [xpost][/xpost]

    I'm trying to achieve below,

    1. Allow specific text as valid input - working fine

    2. If "DO" is entered, the cell needs to be green - working fine

    3. If "DO" is deleted, the cell colour need to be blank - not working

    4. Cell formating(border, font size) should not be able to change - not working

    5. need to set C20:C30 as text only in the same sheet- code not added

    6. hide entire raw if cells in column A is blank - code not added

    this is my code added in sheet 1

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!