Changing color of Row in Excel from VBA 1

[SBendBuckeye]

I have an Excel sheet I am validating using a VBA routine. I am working my way down a specific column. If my routine makes a change during the validation I would like to change the background color of that row to make it easy for the user to spot. How is the best way to do this?

Thanks in advance and have a great day!

 

[RobBroekhuis]

The following works for the currently selected cell:

activecell.EntireRow.Interior.Color=vbred

You can modify if you are using a row counter, e.g.

Rows(iRow).Interior.Color=vbred

Rob