How to lock one cell out of three?

[rangel]

Hi,
First let me thank you for taking the time to read this thread.
I am very new in excel, I have 3 cells (A1, A2, A3) and I would like to know if it is possible to lock one out of the three when two have data. for example;
If I have A1="any number" and A3="any number" I want A2 to be locked/grey out. If I have A2="any number" and A3="any number" I want A1 to be locked.
any help will be greatly appreciated, Thanks in advance!!

 

[rangel]

Re: Help Please! How to lock one cell out of three?

thank you so much sir!!

Change the 15 to 3. If you want to see all of the Color Index values you can choose from, copy/paste this code into the VB editor's Immediate Window (press CTRL+G if you don't see it)...

For X = 1 To 56: Cells(X, "A").Interior.ColorIndex = X: Next

and hit the Enter key... all of the possible ColorIndex colors will be shown in Column A of the active sheet... find a color you like and replace the 15 in my code with row number for that color.