CODEWITHSUNDEEP
excelexcel-formulavlookupconditional-formattingcountif
Bekka
Bekka

Reputation: 23

With Excel Conditional Formatting - Want to Highlight Cells in a range that match any from another range of cells

Sheet One has 5 cells in a row with numbers. (A2:F2)

Sheet Two also has 5 cells in a row with numbers. (A3:F3)

I'd like to highlight sheet one's cells yellow every time that sheet two has a matching number entered. (There will be more rows of data added to each sheet, but I am using the first row only, to keep it simple.

It works with creating a CF equals to, but I need something that applies to a range of data, from a range of data to make this less tedious. Thank you for any tips!

I am using conditional formatting. I have tried Vlookup, Match, and Countif, but I am new to this type of formatting.

(Sheet two's numbers can be placed in a list (column), instead of a row, if that matters)

Upvotes: 0

Views: 541

Answers (1)

Jerry
Jerry

Reputation: 71538

I'd suggest using COUNTIF:

=COUNTIF(Sheet2!$A:$F,A2)>0

Snapshot of Sheet1 and the Conditional Formatting:

enter image description here

Snapshot of Sheet2:

enter image description here

Upvotes: 0

Related Questions