View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Help with a formula

Yes: as it is a function the format is AND(condition1,condition2 etc).
So in your case the formula would be:

AND(A2="AST",A3="Y")

then set your format for the cell.

Hope this helps.

Pete