Conditional Formatting

Joe · Nov 28, 2004

Is this possible and how?

Cell A1

200 each contain an integer in the range 1 - 10.

Same goes for cells F1:K1

I want to conditionally format any cell in A1

200 if it has the same value
as F1 or G1 or H1 or J1
or K1.

TIA

Joe

JE McGimpsey · Nov 28, 2004

One way:

Select A1

200 (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 · Nov 28, 2004

JE McGimpsey said:
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