Results 1 to 4 of 4

Adding only cells coloured using conditional formatting

Threaded View

FranAgrippina Adding only cells coloured... 04-24-2013, 02:11 PM
AndyLitch Re: Adding only cells... 04-24-2013, 02:18 PM
FDibbins Re: Adding only cells... 04-24-2013, 02:26 PM
FranAgrippina Re: Adding only cells... 04-25-2013, 08:49 AM
  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    38

    Adding only cells coloured using conditional formatting

    I have a column within which only cells containing a >0 value are highlighted using colour RGB = 221, 217, 196.

    I wish to sum only these cells, however any VBA I have been able to find specifies it does not work with conditional formatting. Can anyone give me a hand?
    Last edited by FranAgrippina; 04-25-2013 at 08:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1