Cell restriction

[rameshppc]

Hi good after noon,

I am using an excel chart and finding solution to restrict cells in a row for writing, if a particular word will write in a CRITERIA cell the restriction will remove to allow for writing.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]DESCRIPTION
[/TD]
[TD]VR / KYC
[/TD]
[TD]AMOUNT[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Transfer
[/TD]
[TD](ALLOW TO WRITE)
[/TD]
[TD]-
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]DTH
[/TD]
[TD](RESTRICT TO WRITE)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]POST PAID
[/TD]
[TD](RESTRICT TO WRITE)
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

Try "Data Validation", select "Allow" to custom, then enter formula =B2="Transfer"

 

[rameshppc]

Hi Gaz...

Really you are great..
i tried in a cell and its perfectly working...
But, pls advise how to set the formula for all cells in the rows with individual criteria cell name?

i.e.
c2 formula --> =b2="Transfer"
c3 formula --> =b3="Transfer"
c4 formula --> =b4="Transfer"

 

[gaz_chops]

Highlight the whole range that you want it to apply to, then enter the formula as above.

 

[rameshppc]

Oh thanks..

Its absolutely working...

Thanks for your great help...

 

[gaz_chops]

You're welcome.