Larbec
09-05-2016, 02:34 PM
Ive been struggling and i know if this can be done one of you all can tell me. I have several thousand rows to look through various numbers that are 1 through 4 with four different color combinations. Can a Macro or formula look for color with number sequences?I have attached a example"
Lets say I want to search for the 343 in X21:X23 but ONLY want the Red 34 and white 3 not the 343 in X27:X29. Is it possible to search for cells like this? The colors are actually linked from other sheets and in conditional formatting. I am not hung on specific colors but I do need to separate them with color coding of 4 different colors to isolate the patterns. I can color code with shading instead of CF if need be. Thanks you all
Lets say I want to search for the 343 in X21:X23 but ONLY want the Red 34 and white 3 not the 343 in X27:X29. Is it possible to search for cells like this? The colors are actually linked from other sheets and in conditional formatting. I am not hung on specific colors but I do need to separate them with color coding of 4 different colors to isolate the patterns. I can color code with shading instead of CF if need be. Thanks you all