Find value in a Range of Cells and perform Conditional Formatting

[Kamlesh]

I want to apply a Conditional Formula to Game Board (A2 to E6). If these
numbers are found in the range of Result Numbers (F2 to AD2), then the Game
Board numbers background color should change to white.

Sample Excel Sheet Screenshot available here:

http://www.twitpic.com/zec9t

 

[Mike H]

Hi,

Select A2 then drag to select your game board (A2:E6) then apply a
conditional format of

=ISERROR(LOOKUP(A2,$F$2:$AD$2))

Select a colour OK

With F2 AD2 empty all the cells will now be you chosen colour and will turn
white again whn a number in the board matches A2 AD2
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[AG]

What version of excel are you using? The conditional formatting in
very different in version 2007 as compared to all the prior versions.

 

[CellShocked]

I think this is similar to your photo:

http://www.mediafire.com/?ywngm34wfzm

 

[Kamlesh]

Hi Mike,

I am not able achieve this. I tried this both on Excel 2003 and Excel 2010
beta.

Regards,
Kamlesh

 

[Kamlesh]

AG, I am using Excel 2010 Beta. It would be great if I can get a solution
which will work on Excel 2003 and higher.

Regards,
Kamlesh

 

[Kamlesh]

This is the exact solution I am looking for. Can you please share the
formula to do this?

Regards,
Kamlesh