How to freeze a cell on a specific condition

[aashwinjain]

Hi there !!

Could someone please help me with this.

Say i have two cell

A1 and A4

If a specific condtion is met in A1 { Say if value of a1 =3 } then A4 should freeze and should not exept any value.

Help will be much appreciated. Thank you

 

[Smitty]

[*]Can i customize the error message that i get when i try to enter data in freezed cell
[*]also when the cell is freezed based on the condition can i change the cell color to grey

1) Nope
2) When the sheet is unprotected, add Conditional Formatting to color the cell depending on the condition
3) By default all cells on a worksheet are set to Locked, so when the code protects the sheet all locked cells are uneditable. If you want to be able to edit cells, you first need to unlock them. You can do that with Ctrl+A-->Format-->Cells--Protection-->Uncheck Locked.

I didn't use a password to protect the sheet so all you need to do is unprotect it.