Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use cell color as criteria in formula
Hi,
I have column with values. some of the cells are with color. i have index of colors with % (probability) for each color. I try to use formula that sum the column when the colored cells are multiple with the % in the index according the color they have (blank cells will sum regulary). Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use cell color as criteria in formula
Look he
http://www.cpearson.com/excel/colors.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "michael goldberger" wrote in message ... | Hi, | I have column with values. some of the cells are with color. i have index of | colors with % (probability) for each color. | I try to use formula that sum the column when the colored cells are multiple | with the % in the index according the color they have (blank cells will sum | regulary). | Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use cell color as criteria in formula
Can you post an example?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "michael goldberger" wrote in message ... Hi, I have column with values. some of the cells are with color. i have index of colors with % (probability) for each color. I try to use formula that sum the column when the colored cells are multiple with the % in the index according the color they have (blank cells will sum regulary). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color formula | Excel Discussion (Misc queries) | |||
Using cell color as criteria | Excel Discussion (Misc queries) | |||
color a cell with a formula in it? | Excel Worksheet Functions | |||
Can I color a cell if a certain criteria is met? | Excel Discussion (Misc queries) | |||
I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) |