Hi,

Select the rows you want to format in this way then

Format|Conditional Format
Select formula is and enter the formula
=MOD(ROW(),2)=1

Pick your colour
Click OK

Mike

"Daren" wrote:

Hello,

Is there a macro or quick way to highlight alternating rows in color? For
example, row 1 would be gray, row 3 would be gray, row 5 would be gray, etc.

Thanks.