Macro to Conditional Format Columns A:F, Rows 3:end of data

I am trying to format the color of a report so that every other line is blue. The problem I am getting is that data is copied from a table so it already has colors to it, which get messed up when the data is sorted. So I cant conditional format the report prior to running the macro, I need to figure out how to have the formatted colors overpower the colors from the table.

Any help is much appreciated.

Thank you.

the above was to color even row numbers

if you want the odd rows then use below

Please Login or Register  to view this content.

Hulpeloos, you have been a great help! Thank you!!!