I have a sheet filled with numbers in the range A1: A5000
Each day I add a column, so afther one day I have also the column B1:B5000,afther two days I have also the column C1:C5000 and so on each further day.
I want to write a macro that does the following:
If there are 5 numbers in a row who are rising ex. 31 , 20, 10, 13, 17,19, 21 then the cells 10/13/17/19/21 must be changed with interiorcolor : 2
If there are 6 numbers : interiorcolor 3
If there are 7 numbers : interiorcolor 4
Is this possible?
Many thanks.
Each day I add a column, so afther one day I have also the column B1:B5000,afther two days I have also the column C1:C5000 and so on each further day.
I want to write a macro that does the following:
If there are 5 numbers in a row who are rising ex. 31 , 20, 10, 13, 17,19, 21 then the cells 10/13/17/19/21 must be changed with interiorcolor : 2
If there are 6 numbers : interiorcolor 3
If there are 7 numbers : interiorcolor 4
Is this possible?
Many thanks.