Consulting

Results 1 to 3 of 3

Thread: Can you search sort for a specific color and number

  1. #1
    VBAX Regular
    Joined
    Sep 2015
    Location
    East Texas
    Posts
    87
    Location

    Can you search sort for a specific color and number

    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
    Attached Files Attached Files

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    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)
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Regular
    Joined
    Sep 2015
    Location
    East Texas
    Posts
    87
    Location
    Sam,

    How do I set this up on a module?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •