Find with CF repeating number per row in matching color column

%3CLINGO-SUB%20id%3D%22lingo-sub-1356749%22%20slang%3D%22en-US%22%3EFind%20with%20CF%20repeating%20number%20per%20row%20in%20matching%20color%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356749%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20helping.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20find%20and%20highlight%20all%20occurrences%20of%20the%20number%20that%20repeats%20in%20a%20row%2C%20but%20only%20if%20it%20is%20also%20found%20to%20repeat%20in%20the%20same%20color%20column.%20All%20rows%20in%20the%20range%20(table)%20should%20do%20the%20same%20though%2C%20but%20independent%20of%20each%20other.%20In%20other%20words%2C%20if%20one%20of%20the%20%22same%20color%22%20column%20is%20missing%20the%20repeating%20number%20in%20the%20row%2C%20then%20that%20row%20should%20not%20highlight%20anything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20provided%20to%20examples%20to%20illustrate%20this.%20In%20the%20attached%20files%2C%20I%20used%20manual%20highlighting%20just%20to%20illustrate%20the%20scenario%20(it%20needs%20to%20be%20removed%20manually%20before%20applying%20the%20CF).%20That%20highlighting%20is%20the%20one%20I%20need%20done%20by%20CF.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1356749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hello,

 

Thank you in advance for helping.

 

I need to find and highlight all occurrences of the number that repeats in a row, but only if it is also found to repeat in the same color column. All rows in the range (table) should do the same though, but independent of each other. In other words, if one of the "same color" column is missing the repeating number in the row, then that row should not highlight anything.

 

I provided to examples to illustrate this. In the attached files, I used manual highlighting just to illustrate the scenario (it needs to be removed manually before applying the CF). That highlighting is the one I need done by CF.

 

Thanks again.

0 Replies