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.   
      
   Thanks,   
      
   Jim   
      
      
   On Thu, 24 Aug 2006 11:28:24 +0100, Dean Earley   
    wrote:   
      
   >jppl2000@adelphia.net wrote:   
   >> I have more than 3 different choices, ( ab, cd, ef, ghij, kl).  They   
   >> are also aphanumeric, (.01 ab, 6 cd, .50 ef, 8 ghij),etc.  The numbers   
   >> may range from .01 to 8.0.  The letters will always remain the same. I   
   >> would like to change the color of all the ab entries to a specific   
   >> background color, regardless of the number range, and a different   
   >> selected color for the other alpha entries.  If this is possible,   
   >> could I also obtain a sum total of all the numbers ony with the ab,   
   >> then with the cd,and each of the alphanumeric sets?  How to get   
   >> started?  Thanks.   
   >   
   >First question, where are these being displayed?   
   >   
   >You can use split to separate into lines then split again on each line   
   >for the two parts.   
   >Going through each line, you can check the textual part and total up the   
   >relevant numerical parts.   
   >   
   >At the same time, you can then set the colour, but how, depends on what   
   >you are using to display it.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)