Hi everyone, complete newbie here. Hope you can help.
My knowledge of Excel is OK, but pretty basic. Now my boss has asked me to find the answer to something even he can't figure out (and he's loads better than me at Excel)!
spreadsheet exercise.jpg
In the spreadsheet pictured, we have column L, which includes a drop-down menu in each cell.
The customer selects "Accept", "Avoid", "Modify" or "Share". With the last three options, they then need to fill in the cells in cells M to S.
But if the answer is "Accept", they don't.
So my boss has asked me to find a way to "grey out" cells M to S if someone has chosen "Accept" in column L.
This would make it clear to the customer that they don't need to fill in those cells.
I wouldn't know where to start but, if someone could give me the magic formula, you'd be making me - and my boss - very happy.
Thanks in advance,
Andie
Bookmarks