View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
casey casey is offline
external usenet poster
 
Posts: 80
Default conditional formatting from a list

How do I conditionally format a cell if the data in the cell matches any cell
in a list of 100?

For example:

Col A Col B
bob art
jim bob
kirk will
greg sam

I want to format the cells in Col A such that "bob" will fill red with white
letters if his name shows up in Col B