VBA: If row contains value than color fill active cells in row

[mattress58]

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.

[millz]

Edit: sorry double post.

[millz]

This sounds like something that can be done with a simple filtering then formatting, which can also be done with conditional formatting. But if you must use VBA, try this:

Please Login or Register  to view this content.