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

 

[Sektor]

What is "double column"?

 

[Jeff P]

Double column meaning that I have a range comprised of columns B and C,
in which the marker ID's may encompass both column B and C

ABCDEF

..XT
..00
..FF
..SU
..ZZ
..FF
..0
..XX
..FF


thanks

 

[Sektor]

Unclear. There are two cases:
1. Value "XT" is in merged cell "B1:C1".
2. Value "X" - in B1, value "T" - in C1.
Which one?

 

[Jeff P]

Thanks Sektor.. i appreciate your patience.

They are not merged cells
So i guess they would be considered their own cell containing a unique value and formatting.
Although I view them as one marker, they are actually two cells side by side

If it makes things easier.. I can remake my sheet to encompass only a single column. (perhaps its better that way)

If you could make a script to that looks through only a single column ie: B: Range ("MarkerRange) .. that would be great!

My initial concern was to create a script which can distinguish between, say a value, and the same value with a different font formatting, or just a solid color. etc.

If that's possible?



so to re iterate keeping with only a single column

here would be my example beginning with:

ABCD
..X
..0
..F
..S
..Z
..F
..0
..X
..F

and to search for "F"

ABCD
..X
..0
..F X
..S
..Z
..F X
..0
..X
..F X

Thanks

 

[Sektor]

So, you just want to place "X" sign against ID which you selected in "MarkerRange"? Correct?

 

[Jeff P]

Correct.

to place an "X" 3 spaces to the left that matches the exact value and formatting.

As an example, if I chose to identify "F" it will not include the non formated "F", as it is not an exact match.

example:

ABCD
..X
..0
..F
..S
..Z
..F x
..0
..X
..F x

sorry for any confusion.. and thanks for the help.

 

[Sektor]

I don't know why you decided that colored values aren't searchable, but following code works for me. I place your data into column B (replace "F" with the value you search):

Sub SetXes()
    Columns("B:B").Replace What:="F", Replacement:="F   x"
End Sub

 

[Jeff P]

Thanks Sektor

But I may have made things more confusing.
What I'm looking for is a script which will identify a value (and format), and place an "x" 3 cells to the right...within column E
I quickly tested your script, which places an "X" three "spaces" to the right, keeping them in the same cell.

sorry if my example wasn't quite clear..

Also your script does not distinguish between formatting. If I have a red F and a green F it will place an X beside both
I am in need of a script which can distinguish between any value and formatting.

ie: In one case may be trying to indicate all Blue " F"s, in another case I may want to identify all green Z's with a bold font and a blue background.
or I may want to indicate only the cells with yellow fill.

thanks again for the help.

 

[Sektor]

It ain't problem to identify font color. The problem is WHICH colors you want to search for? Interior.Font has two properties for color: Color and ColorIndex. ColorIndex takes number. Color takes RGB function. You must figure out numbers of colors.