Changing Row Color

[xgunda420x]

Does anyone know how to do this using VBA or any other techniques?

Please see attached. I would like to change the font color to red for entire row if column A matches with range B4:G8.

Any help is greatly appreciated.

Thank you.

[Portuga]

You can use conditional formating to all the cells by using the following formula in the conditional formating.
(Start in A12 and then apply the format painter to all cells in your range):

Please Login or Register  to view this content.