PDA

View Full Version : Can you search sort for a specific color and number



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

SamT
09-05-2016, 02:55 PM
THis is from another project

Application.FindFormat.Clear 'Required
Application.FindFormat.Font.ColorIndex = 3 'Format to find

Set Cell = UsedRange.Find(What:="34", SearchFormat:=True)

Larbec
09-05-2016, 04:09 PM
Sam,

How do I set this up on a module?