Echo10,
Not being a programmer, the way I would do it would be this...
Add 2 columns to your data and join the three criteria in one of the new columns (say it's column A). You can do this through the CONCATENATE function. Alternatively, you can simply use '&' between cell references. i.e. =C4&D4&E4
Outside of your data enter the criteria you are searching for in the same format as it is showing in column 1. The type the word "yes" in the cell to the left of the cell where you typed your criteria. So if your criteria is in cell A1, then type "yes" into B1.
The next step is use a vlookup formula. In the second new column you added use the VLOOKUP function to see if each rows criteria matches your defined criteria at A1. So assume you are typing the formula into Column B row 4 =IF(VLOOKUP(A4,A1:B1,2,false).
If a row as the same criteria as you specified in A1 then the result should be a "yes" in the relevant cell in column B. Copy the formula down as far as your data goes.
The last step is to use conditional formatting. Conditionally format each row to say if the cell in column B equals B1 then format the cell with whatever pattern you want. Conditional formatting is available from the Format menu.
If you have a large amount of data to look through, highlighting the row may not be your best option. You may just want to skip the conditional formatting and once you have copied the VLOOKUP formula down column B just use a data filter to single out all the rows with "yes".
Hope that all makes sense...
Cheers,
Bruno.
|
