I've tried using VLOOKUP and HLOOKUP but I'm not finding the solution.

For simplicity:

I want to highlight a cell in B2 IF its value is found in column φ

1. Column φ falls within a specified range (D1:F in the example)
2. The value in cell φ1 is equal to A2

It’s a bit late, so I didn't make the spreadsheet in markdown yet. I'll add that tomorrow if necessary. All help appreciated.

Update... Here's an example of what success would look like:

CodePudding user response：

You can try with this Conditional Formatting in B2

=COUNTIF(INDEX(E1:Z,,MATCH(B2,E1:Z1,0)),A2)

CodePudding user response：

Try this conditional formatting custom formula rule for the range B2:B:

=countif($E$1:$Z, A2)