A script to match criteria

[Jeff P]

I have a double column "BC" which was made into a range ("MarkerRange") that contains an assortment of markers ID's to identify common rows.
as an example:

XT
00
FF
SU
ZZ
FF
0
XX
FF

In some cases the marker ID is a single character, or double, or only a solid color, or a color with a unique boarder color or just a pattern etc..
I have also created a drop down menu in cells JK, range ("MarkerID") which points to the list of marker IDs

Is it possible to create a "script" which will say: If the value "and" formatting from range ("MarkerID") matches anywhere in ("MarkerRange")
to place an "X" 3 colums to the right?

as an example:. if "FF" is selected in ("MarkerID") drop down menu

XT
00
FF x
SU
ZZ
FF x
0
XX
FF x

I have similar scripts which identify values, but none that include exact formatting.

Thanks for any help

Jeff

 

[Jeff P]

I see,

In my initial post, I had mentioned I would be using a secondary range as the target for searching.
I was hoping there was a general script which said: to search the column B for an exact match from the Target range.

What you're saying is that I have to be specific for every search.

So as an example, I recorded the following formatting.. What would it look like if I wanted to find every "F" with the formatting below, and mark an "x" three cells to the right.

thank you




Sub Macro1()

With Selection.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 9
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 9
End With
End Sub




thanks

 

[Sektor]

Listen, Jeff. You want to search for values with extra condition: char color. Thus, you must have codes for colors you want to search beforehand. Understand?