Hello, everyone.
I would like to ask for your help because with conditional formatting I am doing it but it is very difficult to do it for 40 worksheets.
The idea I will attach in a table is:
In a given cell I have some value (number), at the end of the table I have some constant numbers.
I'm trying a macro where I can tell exactly which worksheets (Array (peaches, bananas, paris, etc.) and in exactly specified cells to compare and if it's: greater than or equal to color the cells.
just for Example:
In cell A75, for example, I have 1,500.
Values are 100, 200, 300, 400, 500, 600, etc.
1500+100
1500+200
1500+300 ect.
The check should be done in the cells described by me on this same row A75, for example in cells C75, G75, M75, Q75, etc.
I will also attach a table.
Thank you in advance for your assistance.
row color cells.xlsm