Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/08/Random-Numbers-No-Duplicates.xlsx

In this video I demonstrate how to disable or locks cells based on a value in another cell, or in a drop-down list in another cell. This technique locks cells based on an IF condition.

Table of Contents:

00:00 - Introduction
01:46 - Example 1 - lock and grey out multiple columns based on a value in another column
05:10 - Example 2 - lock and grey out column if value at top of column is "x"
08:54 - Example 3 - lock and grey out cells in column if count of values in column exceeds "x"
12:18 - Example 4 - lock and grey out cells based on values in two other columns
------------------------