Conditional Formatting

dbr001

New Member
Joined
Dec 29, 2020
Messages
6
Office Version
  1. 365
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

New Member
Joined
Dec 29, 2020
Messages
6
Office Version
  1. 365
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.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,651
Office Version
  1. 365
Platform
  1. Windows
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:
Rich (BB code):
=And($A10<>"",$A10=$I$2)
the second would look like:
Rich (BB code):
=And($A10<>"",$A10=$I$4)
etc.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,127,601
Messages
5,625,749
Members
416,133
Latest member
ToseSenpai

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top