This Type of Reference Cannot be Used in a Conditional Formatting Formula. Change to a Single Cell Nicola 2 years ago Microsoft Excel Tips and Tricks This Type of Reference Cannot be Used in a Conditional Formatting Formula. Change to a Single Cell Credit Chester Tugwell