in this scenario, in Column A, I got inputs like x1234,a321,z321

now the problem is that i want to hightlight any inputs that has more
than four

character and if the length 4 , high light the last number with a
colour.

something like this: IF (len(input)4,
highlight_last_no(with_colour)))

can i use MID or trim to return the input result to read the last value
and at the

same time give it a colour?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=479326