I have a pretty complicated spreadsheet where one column has information in black font, another column has different information in red font, and a third column has information in blue font. My employer wants all sets of information in a single column combined with all three colors determining which is which.
Column I shows areas that are out of compliance (in red)
Column J shows areas with warnings (in black)
Column K shows completed surveys (in blue and italics)
Column G combines all of them as Column I, a semicolon in the middle, Column J, and then Column K on a new line.
I am very new at VBA, but understand that I can achieve this using VBA. I'm not sure how, though. Any help is greatly appreciated.
Bookmarks