REPOST: Excel Graybar

Repost from my old blog so I can refer to this in a new post:

I really thought I had posted this, but I can’t find it. I like when printed Excel sheets have some formatting to let you scan the page easily, and graybar (or greenbar) is usually the best way to format. If you just need something very simple, probably the easiest way to get graybar in Excel is to use Conditional Formatting. Here’s what you do:

  1. Select the range you want formatted
  2. Click Format | Conditional Formatting…
  3. Change the dropdown to “Formula Is”
  4. Type in the formula: =MOD(ROW(), 2) = 0
  5. Click the “Format…” button and set your formatting – background color is on the Patterns tab, but you can apply any formatting you want… bold, outline, etc.

This will apply the formatting to even rows and not odd rows. If you add or remove rows, the formatting will adjust because it’s based on the row number. If you need the ODD rows to have the formatting, the formula is MOD(ROW(), 2) = 1. You can even click the “Add >>” button and use both formulas to apply different formatting to both even and odd rows.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Posts

April 2005
S M T W T F S
    Jul »
 12
3456789
10111213141516
17181920212223
24252627282930

del.icio.us bookmarks

Thanks

I would like to thank Mike Hellrich for hosting a couple redirects for me while I sort out my web server problems.

%d bloggers like this: