View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GerryK
 
Posts: n/a
Default Color filled in auto but from where

See if there is something under Format...Conditional formating...


"Cindi" wrote:

i have a spreadsheet that another person created for Project managemet of
dates over multiple release schedules. There is a formula
=IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each
cell. Then something colors in each cell that has a 1 in it. I can't find
what is doing that. Any ideas?