Formatting Alternating Rows with a Color
 

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.

Formatting Alternating Rows with a Color
 

Use Conditional Formatting, with a Formula like:

=MOD(ROW(),2)=1

then set the background colour (Patterns tab) to grey.

Hope this helps.

Pete

On Sep 29, 1:18*pm, 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.

Formatting Alternating Rows with a Color
 

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.

Formatting Alternating Rows with a Color
 

Thanks, that worked well.

"Mike H" wrote:

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.

Formatting Alternating Rows with a Color
 

Thanks!

"Pete_UK" wrote:

Use Conditional Formatting, with a Formula like:

=MOD(ROW(),2)=1

then set the background colour (Patterns tab) to grey.

Hope this helps.

Pete

On Sep 29, 1:18 pm, 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.

Formatting Alternating Rows with a Color
 

You're welcome.

Pete

On Sep 29, 2:06*pm, Daren wrote:
Thanks!

Formatting Alternating Rows with a Color
 

Daren

Pete's formula won't survive through filtering if you intend to do any.

This will keep alternate row colors even when filtering.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP


On Mon, 29 Sep 2008 06:06:00 -0700, Daren
wrote:

Thanks!

"Pete_UK" wrote:

Use Conditional Formatting, with a Formula like:

=MOD(ROW(),2)=1

then set the background colour (Patterns tab) to grey.

Hope this helps.

Pete

On Sep 29, 1:18 pm, 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.

Formatting Alternating Rows with a Color
 

This formula comes unhinged if there are any blank rows. Adjust the range to
the start of the data and make sure the data is continuous if this fails.

"Gord Dibben" wrote:

Daren

Pete's formula won't survive through filtering if you intend to do any.

This will keep alternate row colors even when filtering.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP


On Mon, 29 Sep 2008 06:06:00 -0700, Daren
wrote:

Thanks!

"Pete_UK" wrote:

Use Conditional Formatting, with a Formula like:

=MOD(ROW(),2)=1

then set the background colour (Patterns tab) to grey.

Hope this helps.

Pete

On Sep 29, 1:18 pm, 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.

Formatting Alternating Rows with a Color
 

Good point.


Thanks, Gord

On Tue, 30 Sep 2008 13:24:01 -0700, ~L wrote:

This formula comes unhinged if there are any blank rows. Adjust the range to
the start of the data and make sure the data is continuous if this fails.

"Gord Dibben" wrote:

Daren

Pete's formula won't survive through filtering if you intend to do any.

This will keep alternate row colors even when filtering.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP


On Mon, 29 Sep 2008 06:06:00 -0700, Daren
wrote:

Thanks!

"Pete_UK" wrote:

Use Conditional Formatting, with a Formula like:

=MOD(ROW(),2)=1

then set the background colour (Patterns tab) to grey.

Hope this helps.

Pete

On Sep 29, 1:18 pm, 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.