conditional formating??

C

cjjoo

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?
 
P

Peo Sjoblom

=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)
 
C

cjjoo

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

paul

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
 
Top