Good evening every one and thanks for reading.

I am creating a drop down list in a windows table cell. I created the cell in under the developer Tab using the dropdown list content control option

The cell has the numbers 1 through to 25.

I need the text colour of the number to change.

Green when 1 to 5 I selected

Yellow when 6 to 10 is selected.

Red when 12 to 25 is selected.

Please help