Change Font Color of every other row

hi,
i want to change of font color of every other row

i have a code to highlight every other row

Please Login or Register  to view this content.

so i need a code which one highlight every other row change their fond color too

thank you

You can use Conditional Formatting instead of VBA to highlight and font color every other row

Video: How To Shade Every Other Line in Excel with Conditional Formatting

but if you prefer to do it the "old fashioned" way, (using the same code as you are already using) this changes the font colour to white:

Please Login or Register  to view this content.

Thank you kev
its working as i wanted

and you too AlphaFrog but i will try sruely