Results 1 to 29 of 29

Columns of data ... need a macro that can find differences of 0.06 & Fill Color them

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2007
    Posts
    39

    Columns of data ... need a macro that can find differences of 0.06 & Fill Color them

    Hey guys.

    My eyes spin like crazy when I try to do this manually. I need your help again!

    I have columns of black data that I manually go through and find regions that have cells with values that are 0.06 or more different.

    I then turn these regions into blue colored regions.

    HOW YOU GUYS CAN HELP:

    Is there any way you can design a macro that goes through the spreadsheet and FILL COLOR YELLOWs a cell who is 0.06 or more less then the next cell down?

    This would be so much easier on my eyes, since I usually have 80 columns and 1500 rows of data.

    The blue coloring I still have to do manually because my human instinct is sometimes important there.

    I would be using the FILL COLOR YELLOW cells as quick markers for my regions of interest.

    I've attached a sample worksheet showing what I'd like. (please note the 3 sheets in the sample)

    Thanks so much once again!
    Attached Files Attached Files

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