conditional formating??
 

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

conditional formating??
 

=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

conditional formating??
 

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

conditional formating??
 

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