Find and highlight

[MrsFrankieH]

Hey everyone!

My computer is a Dell and my operating system is Windows 10.

Can someone help me with a formula to solve this problem? I’ve been doing it (looking for the row of numbers) one by one and it takes too much time.

I’d like to highlight numbers (in the same row) with numbers I copy and paste in an “input” section if found in row of numbers. If row of numbers are found, highlight in FOUND/NOT FOUND box (IN GREEN) as well as highlighting (in green) the “found” numbers in the applicable row of numbers. If row of numbers are not found, highlight (fill in red) the NOT FOUND” section.

I’m not sure if I’m describing what my goal is sufficiently (my technical jargon needs work), so I made a detailed illustration.

Thank you so much in advance.

 

[Joe4]

OK, I was able to do all this with Conditional Formatting. Here is how I set it all up.

First, I assumed that my 5 input boxes were in cells B2:F2.
Then, all my data entry boxes were in columns H:L, starting on row 1.
And my FOUND and NOT FOUND boxes were in cells N1 and N2, respectively.

So, first I added Conditional formatting to the large table to highlight the matching row. I did this by selecting all the data at once, starting in H1 and going all the way down to the last cell with data in column L, selecting Conditional Formatting, selecting the Formula option, and entering this Conditional Formatting formula:
=AND($B$2=$H1,$C$2=$I1,$D$2=$J1,$E$2=$K1,$F$2=$L1)
(so we write the formula as it pertains to the first cell in our selection, and it will adjust it for all the other cells in our selection because we have used absolute/relative range referencing preoperly).
Then we selecting the green highlighting option and select OK, and it should highlight the matching row.

Now, to apply Conditional Formatting to the "FOUND" word, we select cell N1, and apply this Conditional Formatting formula to it:
=SUMPRODUCT(--(H:H=B2),--(I:I=C2),--(J:J=D2),--(K:K=E2),--(L:L=F2))>0
and choose our formatting color.

Likewise, for the "NOT FOUND" box, our formula is very similar:
=SUMPRODUCT(--(H:H=B2),--(I:I=C2),--(J:J=D2),--(K:K=E2),--(L:L=F2))=0
and choose our formatting color.

 

[MrsFrankieH]

Bless you Joe4!! I have to go to work now but as soon as I get home, I'll try out your formula!!! Thank you so much!! I'll keep you posted.

 

[Joe4]

You are welcome.

 

[MrsFrankieH]

Hello Joe4!

I just got home, turned on my computer and applied your formula and it works like a charm!!! Thank you so much for your help!! You’re really talented!!

Have a great rest of your week!!

 

[Joe4]

You are welcome!
I am glad it worked out for you.