Conditional Formatting

[Joe]

Is this possible and how?

Cell A1200 each contain an integer in the range 1 - 10.

Same goes for cells F1:K1

I want to conditionally format any cell in A1200 if it has the same value
as F1 or G1 or H1 or J1
or K1.

TIA

Joe

 

[JE McGimpsey]

One way:

Select A1200 (with A1 active), then enter this CF:

Formula is =NOT(ISERROR(MATCH(A1,$F$1:$K$1,0)))

(I'm assuming you didn't deliberately omit cell I1)

 

[Joe]

One way:

Select A1200 (with A1 active), then enter this CF:

Formula is =NOT(ISERROR(MATCH(A1,$F$1:$K$1,0)))

(I'm assuming you didn't deliberately omit cell I1)

Perfect solution - many thanks
[and, yes, omitting column I was a mistake on my part]

joe