I had another question related to this if anybody could offer some help. I'm looking to modify the code to change the shading of the cell rather than the color of the font and was wondering if there was an easy fix for that. Appreciate the help for the VBA beginner! Thanks!