It's about making a macro that checks (I don't mean scrolling because I understand scrolling as moving a row down) the rows of a column, and if it finds an example value 10.80.50.20
, that cell is painted a color. I was thinking of doing it with case
but I'm pretty new to programming. I will leave an example of what I have in mind.
Thank you for your attention and help.
Yes, you can do it with the case function and the for each loop.
Simply select the data range and the function goes through each cell checking its value, in that part the case function enters to check the value of the cell in turn, depending on the value, a fill color is assigned.
It would be something like this:
Ok, add a module after this code:
and f5