Find value in a Range of Cells and perform Conditional Formatting
 

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 he

http://www.twitpic.com/zec9t

Find value in a Range of Cells and perform Conditional Formatting
 

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.


"Kamlesh" wrote:

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 he

http://www.twitpic.com/zec9t

Find value in a Range of Cells and perform Conditional Formatting
 

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

Find value in a Range of Cells and perform Conditional Formatting
 

I think this is similar to your photo:

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





On Sat, 23 Jan 2010 10:58:05 -0800, Kamlesh
wrote:

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 he

http://www.twitpic.com/zec9t

Find value in a Range of Cells and perform Conditional Formatt
 

Hi Mike,

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

Regards,
Kamlesh

Find value in a Range of Cells and perform Conditional Formatt
 

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

Find value in a Range of Cells and perform Conditional Formatt
 

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

Regards,
Kamlesh