Aargh! Help - Find cells, multiple text match

[fallwire]

Hi there,

Really at a loss as to how to do this, though I know it would be VBA coding and not just an IF formula (as I am not looking to have any extra data entered on the 'Form' sheet on the attached workbook). 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. Looks for cells that contain text matches for the all of the first 3 columns of information listed in one row of the Vlookup table. In this example, cell Form!A9 contains text matching row 2 data in the Vlookup table.
2. On discovering the match described 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 last 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.

Other points: a) Vlookup table is not to be sorted in any particular order; 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.

[teylyn]

Please take a moment to read the forum rules, especially about thread titles and duplicate posts. Then please remove the drama from your thread title.

thanks

[fallwire]

Hi temlyn, I don't know how to either change title or delete this message

[teylyn]

No need to delete anything. Maybe time to revisit the forum rules. It's really all in there.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.