Computer Tutoring Logo
Est. 2002
Menu Button

Prohibiting cell entry based on another's value - Online IT Training.


Stop someone accessing one cell based on another cells value

This one was asked by a client who wanted to restrict the input of users based on what the have previously type. For example if they type in Car then one cell is greyed out with Data Validation restrictions placed on it. If they type in Bike the other cell.

There are no exercise files for this.