conditional formatting

S

Stranded N Iraq

how can accomlish this task? When I type text in column A, it appears in
column B automatically in the following format, see below:

column A
<b>abc rugs<br>colors:red, blue<br> size: 2

column B
colors:red:1:1:0:|colors:blue:2:0:0:
 
Top