PC Review


Reply
Thread Tools Rate Thread

AUTO SUM ONLY SPECIFIC COLORED CELLS BY CONDITIONAL FORMATING

 
 
abu abdullah........halsaeed85@gmail.com
Guest
Posts: n/a
 
      25th Nov 2009
HI EVERY ONE
I HAVE THIS EVENT CODE FOR SUMMING DEFINED RANGE

Private Sub Worksheet_Change(ByVal Target As Range)
Dim RNG1 As Range
Dim RNG2 As Range
Set RNG1 = Range("D220")
Set RNG2 = Range("D21")
If Not Intersect(RNG1, Target) Is Nothing Then
RNG2.Value = Application.WorksheetFunction.Sum(RNG1)
End If
End Sub


BUT WHAT I NEED URGENT TO ADD A CONDITION TO SUM (ONLY) AS EXAMPLE ALL
Cells.Interior.ColorIndex = 3 I CONTROL WITH CELLS COLOR WITH
CONDITIONAL FORMATING I HOPE ITS VERY CLAER , I HOPE ANY ONE CAN HELP
APPRECIATED

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Colored Cells that are Conditional Formated tom Microsoft Excel Misc 3 14th May 2010 02:13 AM
Considering cells colored via conditional formatting Faraz A. Qureshi Microsoft Excel Programming 1 29th Jan 2010 11:58 AM
Conditional Formatted Colored Cells =?Utf-8?B?UmljaGFyZCBQ?= Microsoft Excel Programming 1 19th Mar 2007 10:48 PM
conditional formating a specific amount of cells in a row. =?Utf-8?B?amVmZg==?= Microsoft Excel New Users 3 4th Apr 2006 06:07 PM
Conditional Formating - =SUM Colored Cells MS Microsoft Excel Discussion 5 25th Apr 2005 03:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:28 AM.