I am not technically entering information into the row since it is being populated by a pivot table. Will this method work in this case? Also, I didn't see in either set of code where the actual formatting was established. Could you elaborate a little on this or point me towards what you would consider a good reference? Thanks again.