title: Excel - How to lock cell without using macros if possible
body: <p>I have solution implemented using the macro but I want remove it if I can. So here the issue</p>
  
  <p>I have drop-down implemented using validation rule on a cell. I want that cell to be readonly depending on the value in second cell on same sheet.</p>
  
  <p>I tried locking the using another validation but it don't allow me.</p>
  
  <p>Any Idea?</p>