Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) |