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!
Bookmarks