Hello, I would like to conditionally format from the following range:
65
12*
abc
43
55*
150

I would like any number over 50 to be formatted one colour (this would be 50* and 150 from the range - the asterisk is an asterisk and not a wild card)
I would also like the abc text to be formatted another colour.

Any assistance would be gratefully appreciated, thanks