Conditional Formatting

[dbr001]

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.

 

[dbr001]

Got it working - thank you. What about if I want each of the input boxes to reflect a different color highlight.

Ie I2 = yellow highlight, I4 = red highlight, etc. etc.

 

[Joe4]

Got it working - thank you. What about if I want each of the input boxes to reflect a different color highlight.

Ie I2 = yellow highlight, I4 = red highlight, etc. etc.

Then you would set up four rules, one for each cell/color.

So the first rule would look like:

=And($A10<>"",$A10=$I$2)

the second would look like:

=And($A10<>"",$A10=$I$4)

etc.