VBA code selecting text.

[waza81]

I have cells with varied amounts of text. The consistent thing is the top line of text should always be bold.
There are several thousand rows of data. What I would like to do is highlight any errors in cells that don’t have the bold headings. So a code to look for that and maybe fill cell with a colour if found.

Sorry fairly new to VBA.

Thank you

 

[alansidman]

Tough to visualize without some sample data. Please supply a sample of 8-10 records that are representative of your actual data. Then show us a mock up solution. Use XL2BB to upload data. See my signature for instructions on XL2BB