Shade & Lock Cells Based on another cell

[Anarchus]

Hi,

Is it possible to shade and lock cells in a column based on the data on the same row in another column?

In Column A, I will enter either "Asset" or "Peripheral".

In Column B will be the information for anything classified as "Asset".

In Column C will be the information for anything classified as "Peripheral".

Therefore, if I enter "Asset" into A2, I want B2 to be available to enter data into but I want C2 to shade grey and lock the cell (there is information in the other columns from D, so I want to be able to hit the TAB button and it automatically skip over C2 and go to D2).

Then, if I enter "Peripheral" into A3, I want B3 to shade grey and lock so that when I hit TAB, it skips over B3 and I can enter data into C3.

Is this at all possible? I know I can hit TAB once or twice depending on the classification, but I will have other people using the workbook and they tend to make a lot of mistakes and put the wrong information in the wrong column.

[JBeaucaire]

My suggestion is to avoid unnecessary VBA.

1) You can use CONDITIONAL FORMATTING in B2 and C2 to grey the cell out based on the value in A2. (make the cell and the font the same color of grey)

2) You can use DATA VALIDATION in B2 and C2 to make the cell refuse to accept data based on the value in A2.

I wouldn't fret the TAB thing, the Data Validation will not allow typing in the greyed out cell, so no worries there.

[Anarchus]

Thanks JBeaucaire,

The data validation won't work for column B as the value will always be different, out assets start with AA then have 5 numbers after it.

I was also hoping to make the TAB thing work, as we use a barcode reader to scan codes, so if the cell became locked, the barcode reader would automatically skip to the next column, but no worries, thanks for your help anyway.