Making cells mandatory based on the content of another

[JoKeenan]

I hope this is the write forum!

Help!!! I am a complete novice. I am using Excel 2007 and have created lists for several columns, I want it to do 2 things:

1. If a certain option from the drop down list in column C is selected then I want columns D E and F to be mandatory to have content (non specific)

2. If any of the other options from the drop down list in column C are selected (except a particular one) then I want columns D E and F to be greyed out (do not have to be completed)

It is text not numeric data.
Any help would be wonderful! Many thanks

[newdoverman]

This site could be of help to you. It appears that what you want can be accomplished using VBA.

http://en.allexperts.com/q/Excel-105...lds-Excell.htm