View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kays Excel Question
 
Posts: n/a
Default Can you do an IF function whether a cell has a fill color of Rose

I want to get a 1 returned when I quere a cell if the fill color is Rose
(colorindex=38). Do you use the IF function or is there another way to do
it? What is the IF function syntax?