I am trying to create an advanced spreadsheet in excel that caters for people who really need to be told exactly what to do and what not to do. So based on the selection in column A I want to disable and change the background colour of some cells as follows (but only disable the cells on the same row):
<code>columnA = Number then disable cells D, F, G and change to red
</code>
<code>columnA = </code><code>Link then disable cells E, F, G and change to red
</code>
<code>columnA = </code><code>Image then disable cells D, E and change to red
</code> Any help much appreciated, I really my excel/vba skills are really not up to much.
<code>columnA = Number then disable cells D, F, G and change to red
</code>
<code>columnA = </code><code>Link then disable cells E, F, G and change to red
</code>
<code>columnA = </code><code>Image then disable cells D, E and change to red
</code> Any help much appreciated, I really my excel/vba skills are really not up to much.
Last edited: