Conditional format on part of a cell

Hi all

I've used Conditional format before and up to now never had a problem with it

I would like that if a cell ends with a number it turns (eg) yellow

So Hallo1 remains colourless, but in the case of Hallo2 the cell turns yellow

I have tried (in the active cell A20)
Right(a20,1)>1 (with the setting hasFormula) and =Right(a20,1)>1, both without the desired result

What can I do (it must be simple)

Thanks in advance
Hein

Good morning Hein

Originally Posted by Hein

I have tried (in the active cell A20)
Right(a20,1)>1 (with the setting hasFormula) and =Right(a20,1)>1, both without the desired result
What can I do (it must be simple)

You're on the right lines. Try :
=VALUE(RIGHT(A20,1))>=1

HTH

DominicB