| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine color of a cell?
I have a column of numbers that if the cell is a color and another cell is
"Y" then sum the color cells. Below is my example and below that is an equation I tried, but it did not work because the ColorIndex(), appears to not traverse through the Array it only returned the first cell color. I am a rookie at this, so please excuse the poor example. Question: Is there a way to get the "Color Index" for each cell in a row and add the row as I go? Thanks in advance for any help. Example: Row 1: Column A is Y for space charge, Column C is $10 is highlighted RED Row 2: Column A is Y for space charge, Column C is $20 is not highlighted Row 3: Column A is N for space charge, Column C is $40 is highlighted RED Row 4: Column A is N for space charge, Column C is $10 is not highlighted = SUMIF(and(a1:a4="N",C1:C4=indexcolor(44)),c1:c4,0) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to determine color of a cell?
Check out this link...
http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH... Jim Thomlinson "KW" wrote: I have a column of numbers that if the cell is a color and another cell is "Y" then sum the color cells. Below is my example and below that is an equation I tried, but it did not work because the ColorIndex(), appears to not traverse through the Array it only returned the first cell color. I am a rookie at this, so please excuse the poor example. Question: Is there a way to get the "Color Index" for each cell in a row and add the row as I go? Thanks in advance for any help. Example: Row 1: Column A is Y for space charge, Column C is $10 is highlighted RED Row 2: Column A is Y for space charge, Column C is $20 is not highlighted Row 3: Column A is N for space charge, Column C is $40 is highlighted RED Row 4: Column A is N for space charge, Column C is $10 is not highlighted = SUMIF(and(a1:a4="N",C1:C4=indexcolor(44)),c1:c4,0) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to determine color of a cell?
Jim,
Thanks for the information, took me a bit to figure out how to use the information, but once I did it hit the spot. THANKS "Jim Thomlinson" wrote: Check out this link... http://www.xldynamic.com/source/xld.ColourCounter.html -- HTH... Jim Thomlinson "KW" wrote: I have a column of numbers that if the cell is a color and another cell is "Y" then sum the color cells. Below is my example and below that is an equation I tried, but it did not work because the ColorIndex(), appears to not traverse through the Array it only returned the first cell color. I am a rookie at this, so please excuse the poor example. Question: Is there a way to get the "Color Index" for each cell in a row and add the row as I go? Thanks in advance for any help. Example: Row 1: Column A is Y for space charge, Column C is $10 is highlighted RED Row 2: Column A is Y for space charge, Column C is $20 is not highlighted Row 3: Column A is N for space charge, Column C is $40 is highlighted RED Row 4: Column A is N for space charge, Column C is $10 is not highlighted = SUMIF(and(a1:a4="N",C1:C4=indexcolor(44)),c1:c4,0) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
Linear Mode
