Hi, I have values in a cell that changes if the cell next to it changes.
The values are five constant values, i.e. "Critical Criteria", "Non-Critical
Criteria" etc.
I need to colour the cell a different colour based on each unique value.

The conditional formatting only caters for 3 conditions. How do I do this. I
do not have knowledge of using macros.

Appreciate it.