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.
Bookmarks