Conditional read-only

[jerry.ranch]

Hi
I have a data entry spreadsheet.
I want to set the conditional formatting of a series of cells (target
cells), such that if a value is entered in a specific cell, no data
entry is allowed in the target cells. Any suggestions?

Jerry

 

[Bob Phillips]

You want Data Validation with a custom formula of

=cell_ref<>value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[jerry.ranch]

Didn't give all the info..sorry

Those target cells have their own data validation lists as well

I can't use Validataion from a list and a custom validation with the
same cell

Jerry