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

=IF(LEN(A1)4,RIGHT(A1),"")

then use conditional formatting formula is

=B1<""

of course you cannot conditionally format the source cell itself if you
need only part of the string formatted



--
Regards,

Peo Sjoblom

(No private emails please)


"cjjoo" wrote in
message ...

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

so is there a way to format the source to hightlight the last number
using conditional formatting?


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

you can conditional format the actual cell itself but you seem to have to do
each cell separately,cos the formula of Len(a1)4 stays absolute within the
conditional format bar
--
paul
remove nospam for email addy!



"cjjoo" wrote:


so is there a way to format the source to hightlight the last number
using conditional formatting?


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