Hi
I seem to be kind of stuck since the last 15 odd hours trying to figure a solution out for my problem and would really appreciate if someone could help.
I have a timeline in row 1
columns B:S have some data
In the attached excel file you will notice that there are certain cells which have been highlighted in Red which has been done manually which is not a concern. and that's perfect. You will also notice that certain cells are highlighted in blue which are done manually I need these blue cells to highlight automatically
What I need the macro / Solution to do
Find first red cell and then based on the value of the red cell it needs to check the next column for
if red cell is a negative number then look for the first lower value and highlight that cell blue
if red cell is a positive number then look for the first higher value and highlight that cell blue
I have over 100,000 rows of such data and don't think its possible to do all that manually. I would really really appreciate some help...
smallfile.xlsm
Bookmarks