From: dean.earley@icode.co.uk   
      
   jppl2000@adelphia.net wrote:   
   > I have a worksheet which is two pages.  The area that is to change   
   > color and is summed is made up of 4 cells.  The cells are combined and   
   > the data, ( .01 ab or 6 cd, etc) is input into the cell.  It is those   
   > 4 cells that need to change color, depending on the input, as well as   
   > to be summed separately.  There are 365 groups of these 4 combined   
   > cells.  They are all on an excel spreadsheet.   
      
   As it is Excel and VBA (You should have mentioned this earlier) I can't   
   give help but look in the help for conditional formatting and Excel   
   formulas (sum() and iif() will probably be useful.)   
      
   --   
   Dean Earley (dean.earley@icode.co.uk)   
   i-Catcher Development Team   
      
   iCode Systems   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)