Find value in a Range of Cells and perform Conditional Formatting

  • Thread starter Thread starter Kamlesh
  • Start date Start date
K

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
 
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.
 
What version of excel are you using? The conditional formatting in
very different in version 2007 as compared to all the prior versions.
 
Hi Mike,

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

Regards,
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
 
This is the exact solution I am looking for. Can you please share the
formula to do this?

Regards,
Kamlesh
 
Back
Top