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 3 3910 jp******@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.
--
Dean Earley (de*********@icode.co.uk)
i-Catcher Development Team
iCode Systems
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
<de*********@icode.co.ukwrote:
>jp******@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.
jp******@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 (de*********@icode.co.uk)
i-Catcher Development Team
iCode Systems This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: mehmetmutigozel |
last post by:
I was thinking about something like the following;
>>> a=
Traceback (most recent call last):
File "<stdin>", line 1, in ?
NameError: name 't' is not defined
>>>
or
|
by: Abhijit |
last post by:
I am working in a data warehousing environment which gets sourced from
Oracle ERP (AR/GL/AP). The dimensional entities associated with
incoming data are GL Code (e.g. 110), Department (e.g. 1050),...
|
by: Kristen |
last post by:
I need to query an Access database via VB and get a count of all the
calls where the start time is between a 2 certain days/times.
For example, all the calls that occurred from Saturday @ 8am to...
|
by: Diogo Alves - Software Developer |
last post by:
I'm tring to override the combination all the combination like this one Ctrl
+ Shift + . I just can't catch it... I have already done this
for ctrl + or Shift + but for both at same
timeI can't...
|
by: aka_eu |
last post by:
I have this problem.
I'm trying to get all the valid combination C(N,K) that pass one
condition.
For example C(5,3) can use in any combination this numbers {1,2,3,4,5}
But let's say that I...
|
by: fonzie |
last post by:
Is there any way to include two unbound text boxes (for a start date
and end date) to a filter-by-form? The users may want to filter by
several different fields and they may want to include a date...
|
by: Hetal |
last post by:
I am working on Visual Basic 2003 and i had a question about date
functions. Is there a way to get the date range for a week based on
the combination of 1) Week of the year and 2) Year? I mean, is...
|
by: Taxman |
last post by:
Windows XP, MS Office Excel 2003
If the tasks, I’m trying accomplish have been addressed previously (separately or in combination). Please, provide the links or keyword search to find them. I’ve...
|
by: iain654 |
last post by:
I have finally worked out how to automatically send a range of cells in the body of an email using Outlook but it is very clumsy and I have to build up the email using the limit of line...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |