LinkBack URL
About LinkBacks
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.
Register To Reply
Bookmarks