Results 1 to 6 of 6

Thread: Need Excel Help

  1. #1
    hashibhai111 is offline Senior Member+
    Last Online
    2nd September 2016 @ 09:26 PM
    Join Date
    19 Jul 2011
    Location
    UAE
    Age
    34
    Gender
    Male
    Posts
    736
    Threads
    88
    Credits
    825
    Thanked
    55

    Default Need Excel Help

    Guys Assalam o Alikum!

    Muja ya pochna ha kai! agar kuch rows excel mai colour kar di jaein to kya unko count kiya ja skta ha?
    mean
    10 rows hain, mai 5 diffent rows ko Green colour da raha haoin!
    mai ab un 5 rows ko aik cell mai dekhta chahta ho ka wo show kr da ka total mai
    5 rows green hain!
    Thanks!

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote hashibhai111 said: View Post
    Guys Assalam o Alikum!

    Muja ya pochna ha kai! agar kuch rows excel mai colour kar di jaein to kya unko count kiya ja skta ha?
    mean
    10 rows hain, mai 5 diffent rows ko Green colour da raha haoin!
    mai ab un 5 rows ko aik cell mai dekhta chahta ho ka wo show kr da ka total mai
    5 rows green hain!
    Thanks!
    1. Press Alt+F11
    2. Insert k Menu m Module select karain aur ya code paste kar dain.

    Code:
    Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean)
    
        Dim rCell As Range
    
        Dim lCol As Long
    
        Dim vResult
    
      
    
        lCol = rColor.Interior.ColorIndex
    
    
    
        If SUM = True Then
    
            For Each rCell In rRange
    
                If rCell.Interior.ColorIndex = lCol Then
    
                    vResult = WorksheetFunction.SUM(rCell, vResult)
    
                End If
    
            Next rCell
    
        Else
    
            For Each rCell In rRange
    
                If rCell.Interior.ColorIndex = lCol Then
    
                    vResult = 1 + vResult
    
                End If
    
            Next rCell
              End If
    
       ColorFunction = vResult
    
    End Function
    I assume k ap ki A1 sa A10 tak rows color hain. Tu ap ya formula istimal karain. Lekan ap ko ya karna pare ga k C1 ko bhe wohi color karna pare ga jo k ap count karna chahte hain, for example agar ap green rows ko color karna chahte hain tu c1 ko bhee green karna pare ga.

    Code:
    =ColorFunction(C1,A2:A12,FALSE)

    Regards,

  3. #3
    GMD's Avatar
    GMD is offline Senior Member+
    Last Online
    13th September 2015 @ 02:33 PM
    Join Date
    05 Feb 2009
    Location
    Rahim Yar Khan
    Age
    43
    Gender
    Male
    Posts
    445
    Threads
    45
    Credits
    990
    Thanked
    14

    Default

    koi fariq nahi parey ga
    SAFE MY PAKISTAN

  4. #4
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    اپنا سوال پھر سے واضح کریں دو چیزیں مکس ہو رہی ہیں
    ایک ڈیٹا اور دوسرا ٹوٹل

  5. #5
    hashibhai111 is offline Senior Member+
    Last Online
    2nd September 2016 @ 09:26 PM
    Join Date
    19 Jul 2011
    Location
    UAE
    Age
    34
    Gender
    Male
    Posts
    736
    Threads
    88
    Credits
    825
    Thanked
    55

    Default

    Bro mean total sirf usko karna chahta ho!
    Jo colour hoin!
    yahan 2010 ki excel sheet attach nahi ho rahi warna sample dekha deta!

  6. #6
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote GMD said: View Post
    koi fariq nahi parey ga
    Ap ki bat samajh nahee aae mujhe. Kya explain karain ga ap?

Similar Threads

  1. Answered MS Word Ki file ko JPG me kesy convert kru?
    By 1heart2pain in forum Ask an Expert
    Replies: 10
    Last Post: 24th May 2010, 02:34 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •