Could some kind soul help me with at least the outline of a macro to scan a table containing RGB settings and apply those settings to the text and fill of adjacent columns?
My table has these 6 columns: R G B Fill Text Comments. The first row is a header with that text. The subsequent rows contain RGB settings (0-255) in the first three columns, nothing in the Fill column, and text in the last 2 columns.
I would like a macro that would scan the table, extract the RGB settings from the first three columns, then set the fill in column 4 and the text in columns 5 & 6 to those settings.
Here's a sample table:
Code:
R G B Fill Text Comments
0 0 255 Sample text Pure blue
0 255 0 Sample text Pure green
255 0 0 Sample text Pure red
255 255 0 Sample text Pure yellow
94 38 18 Sample text Sepia
230 230 250 Sample text Lavender
178 34 34 Sample text Firebrink
The macro would set the fill color in the Fill column and the and text color in the last 2 columns to the corresponding RGB colors.