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?




Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies