Home

Permuted Conditional Formating to multiple columns

JZucker50
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?

 

thanks!

 

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