Thread: Find value in a Range of Cells and perform Conditional Formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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


Reply With QuoteReply With Quote