Hi folks,
I am building a spreadsheet which contains an inventory list and what I need to do is have 4 query boxes on the top of the spreadsheet which you can enter total of 4 part numbers (each in each own cell) and then when you have these entered the spreadsheet will highlight the 4 matching part numbers in the spreadsheet and highlight that items entire row and will keep the rows highlighted until the query boxes part numbers are changed.
I would assume this is done by conditional formatting.
Let me know how this is doable. Greatly appreciate your help.
I am building a spreadsheet which contains an inventory list and what I need to do is have 4 query boxes on the top of the spreadsheet which you can enter total of 4 part numbers (each in each own cell) and then when you have these entered the spreadsheet will highlight the 4 matching part numbers in the spreadsheet and highlight that items entire row and will keep the rows highlighted until the query boxes part numbers are changed.
I would assume this is done by conditional formatting.
Let me know how this is doable. Greatly appreciate your help.