Posted to microsoft.public.excel.programming

external usenet poster

Posts: 72

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel color functions	foxspirit	Excel Worksheet Functions	1	February 23rd 06 06:22 PM
Using Excel functions to color a cell	Michael	Excel Discussion (Misc queries)	2	December 17th 05 12:23 PM
How do I identify cell color for comparison?	Jackyl71	Excel Worksheet Functions	3	September 27th 05 08:29 PM
Identify Cell Color Index	Voskre	Excel Programming	7	July 25th 04 12:10 AM
Identify rows with certain background color?	DonLi	Excel Programming	4	January 23rd 04 10:38 PM

All times are GMT +1. The time now is 03:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us