Protect cells from writing with condition

**pansovic** · 08-13-2010, 05:55 PM

In cell A1 I can choose between apples, pears, oranges. When I choose apples than I have to write a number in B1 but when I choose pears I have to write a number in C1 and for oranges in D1.
Is it possible that when I choose apples automatically cell C1 and D1 get blocked from writing and when I choose pears the cell B1 and D1 will get blocked?

**grizzly6969** · 08-13-2010, 11:41 PM

in B1 Data / Validation / Custom Formula =if(A1="apples",true)
in C1 Data / validation / custom / formula =if(A1="pears",true)
in D1 Data / validation / custom / Formula =if(A1="oranges",true)

**grizzly6969** · 08-14-2010, 06:06 AM

Now if you want to get funky in cell B1 change font to white then in conditional format --
formula =$A$1="apples" and set font colour to black

**pansovic** · 08-16-2010, 05:31 PM

I already have used in most of the cell Data validation. Can I use 2 different data validation for 1 cell? It looks like it doesn't give me that option.
Your second idea of font white neither works as that there is nothing written. It is the idea to block the cell in order not being able to write anything.