Thread: Match different sheet values then highlight rows that meet criteria.

Can someone help me?

Please see attached example. I want to match an exact number in a cell to an array of numbers in another sheet. Where they match I want to highlight the entire row (example all of 2) or a particular range of cells (say from A2 – S2).

The solution I was trying was to have a column (A1) that ran the function (=MATCH(B5,Static!A5:A15,0)) then conditionally format the entire row red where there was a value of 1. Then I would just hide the column.

But, if someone has an even better idea I am open to it.

Thank you!

If i have correctly understood your request.

You want a formula in col a Variable sheet which looks at the values in col b of the same sheet. If any of these values match any value in static sheet you want this value to appear in col a of variable and highlight the row in red.

So per your sample,

In A2

=IFERROR(INDEX(Static!A:A,MATCH(B2,Static!A:A,0)),"")

copy down to A18

Then for the formatting > highlight A2:I18 and in conditional formatting enter =$A2=$B2

Hope this helps, if not let me know

just adjust the Applies to: section of conditional Format to whatever cells you want hightlighting.

on your sample tell me which cells you would like highlighting

thanks for the feedback - glad to help. Pls don't forget to mark as solved, Cheers

Click EDIT on the original post, then click the Go Advanced button, then change the status. Somethin like that!