Use both "Data Validation" to control the entry rule and "Conditional
Formatting" to control the format.


--

Regards,
Nigel




"LRay67" wrote in message
...
I have this spreadsheet that if the user enters data in one cell I do not
want them to enter data into another cell. How can I accomplish this?
Also
is there a way to put the cell that I don't want them to enter data into
be
grayed out? Any help would be appreciated. Thanks