View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ at home CJ at home is offline
external usenet poster
 
Posts: 1
Default multiple condition lookup and match cell format

Sheet 1: A 35 cell column, each with user intials "XXX", each cell is
formatted with font and pattern choices.
Sheet 2: Cells A1:M15. If the contents of a cell matches one of the cells
in Sheet 1, match the contents and the format of that cell.
Can't use conditions, because there are only three. I'm hoping I just don't
get arrays yet.