Hi
I am trying to highlight cells that have had manual enries of text and numbers into either Red, amber or green.
The possible text would be Red, Red 5, Red 6, Red 7 to highlight Red
Amber 7, Amber 8, Amber 9, Amber 10, Amber 11, Amber 12, Amber 13 to highlight Amber
Green, Green 14, Green 15, Green 16, Green 17, Green 18 to highlight Green
...anything else not to change

I managed to get them to change for the Red range but not all of the others?

Can anyone help please and let me know what i need to do .

I use Excel 2003

Thanks