Permuted Conditional Formating to multiple columns

Copper Contributor

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?

 

thanks!

 

0 Replies