Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using the functions of the excel to identify if a color in the cellchanged
Hi
i will need to build a sum using the functionalities of excel to identify if a cell change his color for example only green cells should be counted 1(white) 2(white) 3(green) 4(green) ------------ the sum will be 7 it is very easy to do it via vba but i would like to do it via the functionalities of excel is it posible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using the functions of the excel to identify if a color in the cell changed
Excel formulas cannot see the colors in the cells; so if you are manually
coloring them, then you can't do what you want. However, if the cells get their color from Conditional Formatting, then you should be able to build your worksheet formulas using the logical formulas from the Conditional Format. -- Rick (MVP - Excel) "thread" wrote in message ... Hi i will need to build a sum using the functionalities of excel to identify if a cell change his color for example only green cells should be counted 1(white) 2(white) 3(green) 4(green) ------------ the sum will be 7 it is very easy to do it via vba but i would like to do it via the functionalities of excel is it posible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using the functions of the excel to identify if a color in the cell changed
First of all no event is triggered when a user changes a cell format, though
things may update in the next calculate event. That aside, from what you describe I think you'd be better off with VBA. The only non-VBA way I know of is with a named XL4macro formula, which will be restricted to returning the format of a cell that's always in the same offset to the cell containing the named formula. Regards, Peter T "thread" wrote in message ... Hi i will need to build a sum using the functionalities of excel to identify if a cell change his color for example only green cells should be counted 1(white) 2(white) 3(green) 4(green) ------------ the sum will be 7 it is very easy to do it via vba but i would like to do it via the functionalities of excel is it posible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel color functions | Excel Worksheet Functions | |||
Using Excel functions to color a cell | Excel Discussion (Misc queries) | |||
How do I identify cell color for comparison? | Excel Worksheet Functions | |||
Identify Cell Color Index | Excel Programming | |||
Identify rows with certain background color? | Excel Programming |