View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brandon Brandon is offline
external usenet poster
 
Posts: 58
Default How do you create IF function with YES/NO, and Color fill

How do you create an IF function to color fill a cell with, for example,
green if YES is entered, or red if NO is entered?? For example: IF(I3:I120,
"YES" THEN COLOR=0,176,80) and IF(I3:I120, "NO" THEN COLOR=255,0,0).

thanks,
Brandon