I am using the code below to generate 5 random names based on a target value. I have a list of names in column A and values for each in column B. The code pastes the names from column A across starting in column K. I want to color code the name by change the cells background color or text color and have it show up that way in the new cell after the Macro runs. Is this possible?
Please Login or Register to view this content.
Bookmarks