Changing format of cells that contain multiple matches of text taken from Vlookup

Hi there,


What I am looking to have is for me to select a range THEN be able to run a macro that does the following:

1. Find cells that have a text match for all of the first three columns of information listed in a single row of the Vlookup table. In the example attached, cell Form!A9 contains text matching the contents of A2, B2 & C2 (ie. has to be on the same row) in the Vlookup table ("CANT" & "16Jun10" & "1-5.25")

2. On discovering a cell that matches the description in step 1, format the contents of this cell a colour.

3. The colour decribed in Step 2 is determined according to the designation of the 4th column of data in the VlookUp table which has possible values [F,S,M]. F should result in RED green coloured text, S should result in GREEN coloured text and M should result in BLUE coloured text. Rating "F" would apply to the contents in Form!A9 as it is in Vlookup table row 2(this is the row in which text in A2, B2, C2 were all to be found in FORM!A9).

Other points: a) Vlookup sheet data is does not have a single unique identifier on which to order it with; and b) The cells of interest in 'Form' worksheet often contain combinations of numbers and letters.

If anyone can work that one out, I would be very grateful.

Thanks

Trent

Give this a try:

Please Login or Register  to view this content.

Originally Posted by fallwire

Does your coding already incorporate that?

General rule of thumb is to try the solutions offered on a copy of your data and then respond on the forum as to your results.

Yes, it matches all 3 values before applying a color.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.