Conditional Formatting - Numbers & Word

I have a drop down Data list of:

- N/A
- 5
- 4
- 3
- 2
- 1

For instance "N/A" will be the default cell option which I would like to always have the background of gold. If "1" or "2" is selected then it would have a red background, if "3" is selected then it would have an Amber background and if "4" or "5" is selected it would have a green background.

I am running into difficulties as conditional formatting option gives only 3 options which means I unable to conditional format "N/A" to have the required Gold default background preset or if selected again after another option has been chosen.

I would be exceptionally grateful if anyone could offer a solution to my problem.

Thanks in advance.

Maybe you could make a table that the conditional formatting refers to, which would provide the colors you want if the condition is met.

Hi, Hope this would help