Search results

  1. M

    Clear cell depending on data validation

    Thanks for the kind words XLEAccessGuru I was very surprised at the reception I received at the hands of Chergh. As you say, I was in a hurry but had been searching for an answer for some time. Generally I found that the way I wanted to do it wasn't possible. I did do a search on this forum...
  2. M

    Clear cell depending on data validation

    Chergh Have done that and it works. I was fixed on Data Validation and drop down lists and did not register with Combo Boxes. Thank you.
  3. M

    Clear cell depending on data validation

    I deleted my reply because I thought it was snotty. Please see edit comment on first post. I did search this forum, and I could not find anything relevant - plenty that was close. I have now searched on what you suggested and again I can find nothing really relevant.
  4. M

    Clear cell depending on data validation

    I came here for answers to a question which was asked politely and coherently. So what is your point/problem?
  5. M

    Clear cell depending on data validation

    Thanks for this helpful reply. I have searched this forum and the internet. I chose this forum because most people got help whereas on other forums there were loads of question with 0 replies. Any ideas on what to search for... "Blank", "Data Validation", "need formula to output to different...
  6. M

    Clear cell depending on data validation

    Hi I have a cell which has a "Yes/No" drop down as an answer to a question. If this Cell (say B1) is set to "No", then conditional formating sets C1 to grey colour and if the cell is edited an error message (through a Custom Data Validation) returns an error message - to all intents the cell is...
Back
Top Bottom