Any one can help me to correct below VBA

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    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