Code to disable a cell in excel
Ok i've looked all over but i am new to excel and don't know how to change
the advice people have given to others to suit my own purposes.
So my question..
I am making a spreadsheet form that people are going to be filling out using
both text and numbers.
Most of the sheet will be unlock, but i want certain cells to be visible
(but greyed out) when another cell has a certain value.
for example this code would be in E5 -- =If(D5=15,2,"grey out E5")
IE if D5=15 then the value in E5 would be 2, otherwise E5 would be greyed
out and unaccesable.
Is this even possible? thanks in advance.
Athens
|