range and combination

[jppl2000@adelphia.net]

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.

Jim

[Dean Earley]

Re: range and combination

jppl2000@adelph ia.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.

--
Dean Earley (dean.earley@ic ode.co.uk)
i-Catcher Development Team

iCode Systems

[jppl2000@adelphia.net]

Re: range and combination

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
<dean.earley@ic ode.co.ukwrote:

>jppl2000@adelp hia.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.

[Dean Earley]

Re: range and combination

jppl2000@adelph ia.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@ic ode.co.uk)
i-Catcher Development Team

iCode Systems