I'm trying to find a VBA code that will search a particular range, for example A1:D300 on Sheet 1, for the phrase "Discounts Applied" and will increase the font to 16 and bold it. That particular phrase will be the only phrase in the cell it is located in. If it doesn't find that exact phrase then it does nothing. Basically what I have is a spreadsheet with a Print button and that phrase is a moving target from one day to the next so I was going to incorporate a code that will search for that phrase and put it in bold and 16 font in the same Print vba code so it does it just before it prints.