Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formula
Hello,
I need to sum cells based on color coding. I am unable to determine how to do this in the conditional format. Thanks for your help Rose |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formula
You can't do this directly with a standard function. However, this site
shows how you can do so with User-defined functions: http://www.cpearson.com/excel/colors.htm About half-way down the page is a section on: "Summing the value of cells based on a specific colour" which is relevant to your request. Hope this helps. Pete Rose Davis wrote: Hello, I need to sum cells based on color coding. I am unable to determine how to do this in the conditional format. Thanks for your help Rose |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formula
Dear Rose...Are u asking to know "HOw to" conditionally format a cell with
pre-selected colors? Or you want to sum cells per color coding thru conditional formulation?. "Pete_UK" wrote: You can't do this directly with a standard function. However, this site shows how you can do so with User-defined functions: http://www.cpearson.com/excel/colors.htm About half-way down the page is a section on: "Summing the value of cells based on a specific colour" which is relevant to your request. Hope this helps. Pete Rose Davis wrote: Hello, I need to sum cells based on color coding. I am unable to determine how to do this in the conditional format. Thanks for your help Rose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |