Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/03/this-type-of-reference-cannot-be-used.xlsx

In this Microsoft Excel video tutorial I explain why you are getting the following error:

'This type of reference cannot be used in a Conditional Formatting Formula.
Change the reference to a single cell..."
------------------------