Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Alternating Rows with a Color
You're welcome.
Pete On Sep 29, 2:06*pm, Daren wrote: Thanks! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternating Color Rows | Excel Discussion (Misc queries) | |||
insert cells in alternating rows? | Excel Worksheet Functions | |||
Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
How do I set an auto alternating row color? | Excel Discussion (Misc queries) | |||
Alternating colors for rows | Excel Discussion (Misc queries) |