Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting to a RANGE of cells | Excel Discussion (Misc queries) | |||
Conditional formatting a range of cells. | Excel Discussion (Misc queries) | |||
Conditional formatting a range of cells | Excel Worksheet Functions | |||
Conditional formatting for range of cells? | Excel Worksheet Functions | |||
How to find cells with non-conditional formatting? | New Users to Excel |