I want to disable a cell in excel based on another cell which contains alphanumeric values / no particular values can I get a formula which will work

[Hint]

want to disable a cell in excel based on another cell. Can I get a formula which will work for this scenario using conditional formatting in excel

 

[jasonb75]

You could use a custom data validation rule on the cell to be disabled.

A formula in the validation rule that equates to TRUE will allow you to enter anything into the cell, a rule that equates to anything else will prevent the cell from being changed.

 

[Hint]

You could use a custom data validation rule on the cell to be disabled.

A formula in the validation rule that equates to TRUE will allow you to enter anything into the cell, a rule that equates to anything else will prevent the cell from being changed.

But I want to make it disabled by applying some fill on cell , so conditional formatting will be appropriate for it .
Example :if c and d column has any values ,d and e column should be disabled by greying out .

 

[jasonb75]

You can grey out the cell by using a simple formula rule, =A1<>"" applied to any cell will apply the rule when A1 contains data, this can be applied anywhere it is needed.

Conditional formatting will not disable the cell, it will only change the colour. People will still be able to change what is in the cell, if you want to stop them from changing the cell altogether then you will need to use data validation, for that the rule would be =A1=""

Note that you can use both on the same cell in order to disable entry and grey out. Anything that was already in the cell before the rule was enforced would remain hidden in the cell, to delete it would require vba.

 

[Hint]

You can grey out the cell by using a simple formula rule, =A1<>"" applied to any cell will apply the rule when A1 contains data, this can be applied anywhere it is needed.

Conditional formatting will not disable the cell, it will only change the colour. People will still be able to change what is in the cell, if you want to stop them from changing the cell altogether then you will need to use data validation, for that the rule would be =A1=""

Note that you can use both on the same cell in order to disable entry and grey out. Anything that was already in the cell before the rule was enforced would remain hidden in the cell, to delete it would require vba.

Thank you ,it worked