To flag or mark a value or selection as invalid when it is equal to a particular value or selection:
-
Select the cell you want to add a rule to.
-
On the Properties tab, scroll down to the Invalid If or Raise Flag If sections.
-
For checklist item type cells, select Choice
. For number and integer type cells, select Equal
.
-
Select or enter the value you want to flag or invalidate.