Permuted Conditional Formating to multiple columns

Occasional Visitor

I have a table where I need to separe permuted numbers disposed at different collumns


for example


"1 1 2"  I need to conditional format exactly "1 1 2"  from for example  "1 1 1 2 2"


but the options are maded "per column" and always put collors at all


also with other columns quantities from 2 to 30 columns in some cases


"reading from left to right"


please, how can I declare to Excel put collors only to the exactly desired numbers multiple columns sequenced group?




0 Replies