Assumptions for the operation of the following macro:
1. between the last and penultimate table there is an empty row (in the example "Stock comparison 2", row 43 is empty).
2. between the first three tables, the rows are not empty (cells C22 and C32 contain the value "lm" and there are formulas in rows 23 and 33)
Color the fonts in the selected column in the last table and select the cell with the header. Run the macro.
The task can, of course, be solved in 100 other ways, analyzing the location and content of the tables in more detail. For now, this is one of the simplest solutions.
Artik
Bookmarks