Find value in a Range of Cells and perform Conditional Formatting


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
 
Ad

Advertisements

M

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.
 
A

AG

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

Kamlesh

Hi Mike,

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

Regards,
Kamlesh
 
K

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
 
Ad

Advertisements

K

Kamlesh

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

Regards,
Kamlesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top