I have a header (row 1) in my worksheets that I need to fill with a specific color (ColorIndex 13 – purple color), but only in the cells in that row that have text. For example, sometimes the header will go to Col H, sometimes to Col K, etc. Trying to write a macro that will only fill the row with color with cells that contain text.

Help is much appreciated, thanks!