Is it possible to create a macro that follows the following conditions?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
If any cell within the range a6:h200 is selected then that cell will have the word “no” entered into it. This should happen only when the cell is blank.<o
></o
>
<o
> </o
>
If the cell is not blank and it is selected within the same range then the cell should now be cleared.<o
></o
>
Thanks in advance for any help at all regarding this matter.




<o


If any cell within the range a6:h200 is selected then that cell will have the word “no” entered into it. This should happen only when the cell is blank.<o


<o


If the cell is not blank and it is selected within the same range then the cell should now be cleared.<o


Thanks in advance for any help at all regarding this matter.