I currently have a macro that produces a grid with multiple names within each cell in the gird.
I would like to create a macro that runs after the gridding macro that does these things:
1. Loops back through the list of names and their data and determines if a quality about them is true or false, then I want it to switch over to the worksheet with the grid and bold their name, if the condition is false, I want to it leave it in regular text format.
This is what I have so far, but obviously this will bold the entire cell, and not the individual names.
VB Code:
If MyCell .Value= Like "Name" then MyCell.Font.Bold = True Else MyCell.Font.Bold= False




Reply With Quote