I would like the macro to go down the sheet and if the value in the cell is "Greg" then color fill all the cells blue and Font color white the active cells in that row. All of these will be in column D(thats where text starts in all rows). So if D12 has "Greg" in it than it will color fill blue & font color white all the cells from "Greg" right until it gets to a cell the is "".How can I write this in VBA. Thanks for help.