Hello Paul_Hossler,
I'm very glad that we're writing again.
So, let me start like this - in the tests we did then for the macro above, we really started from column A, but over the years the table grew and for each subsequent year, I changed where it should start checking and making comparisons and then coloring the cells.
So whether it will be column A or some other EO, EM, AZ doesn't matter. It starts from a selected column and checks each row, where at the end of the table there are set values and starts coloring, if there are no values at the end of the table it skips the row and does so up to and in the range that is set. No matter if it is 2 or 200 rows.
The macro simply works super fantastically and correctly.
Now, however, since there are some changes, I need to do the same thing again, but to be able to record exactly from which column and which row to start checking to the right and if it matches the given amount to color the cells.
In the example, I have given a small part of the table and the idea is - from where it is brown, from there to start checking to the right. I record the initial brown cells, and in the example you will see all of them. S5, Q6, M8, T9, etc. to where the range is defined (as in the other macro)
This as a postscript - Yes, we will do tests, again from column A, but in my table they will be completely different.
Thank you very much and I remain at your disposal!
P.S. - And one more thing, is it possible for the columns not to be with numbers but with their letters?
Reply With Quote