Hi,
I will appreciate your help in a required VBA solution:
I have a table contains values with columns headers (above) and rows headers (at the left).
I need to color all values cells in the table according to the combination of their Rows and Columns headers names. *** No matter what the cell's value is ***.
Note that the are a few combinations of row & column header that code should refer to.
For example:
- For each cell that its row header name = "AAA" and its column header name = "JJJ", then color the cell background in Yellow.
- For each cell that its row header name = "BBB" and its column header name = "KKK", then color the cell background in Green.
- And etc....
Else - Don't color the cell. Leave it as is.
Note that the table changes in its number of Rows & Columns, so the code must support this action dynamically.
Can you please advise how to write the code for this need?
Thanks in advance
Bookmarks