+ Reply to Thread
Results 1 to 2 of 2

Pattern Search Of Conditional Formatting Color in Spreadsheet

  1. #1
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Pattern Search Of Conditional Formatting Color in Spreadsheet

    Anyone know how to write a VBA to do a pattern search of a spreadsheet where Conditional Formatting has highlighting a cell to a certain color (green for this example)?

    My spreadsheet has 200,000 rows with data points and I would like to know if any of the data patterns repeat themselves(ie A1:AN1, the highlighted pattern of cells A1,D1,I1,O1,U1,AH1)? I've included a sample of my spreadsheet. Some of my data points have a higher value then 1, but I've just used 1 in the example to make it easier. Thanks

    DataLog.xls

  2. #2
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Pattern Search Of Conditional Formatting Color in Spreadsheet

    Anyone able to help me with this?

+ Reply to Thread

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