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:
  1. If MyCell .Value= Like "Name" then
  2. MyCell.Font.Bold = True
  3. Else
  4. MyCell.Font.Bold= False