Смотрите свойства Font и Interior объекта Range
Font Property
Interior Property
How to: Change Formatting in a Row that Contains a Selected Cell