How do I "highlight" every other line on a spread sheet?
 

I have a "Rate Sheet" that is forwarded from Accounting Department that has
so much info on it, that I refer to on a regular basis. I would like to know
how to high-light every other line, because it makes it easier to read. It is
much too time consuming to do each line individually. Can anyone help?

How do I "highlight" every other line on a spread sheet?
 

Select the rows you want to apply the formatting to and do the following:

Click FORMAT in the menu and select CONDITIONAL FORMATTING.

In the combobox in CONDITION 1, change the option VALUE IS to FORMULA IS

In the text box to the right of the combo box enter the following formula:

=MOD(ROW(),2)

Then click the FORMAT button, click the PATTERNS tab and select the color
you want to use (lt. green perhaps) and click the OK command button to apply
the format.

The MOD divides a value by a specified divisor MOD(Value, Divisor) and
returns the remainder.

The ROW() function returns the current row number.

Dividing any row by 2 will produce a 0 for even rows and a 1 for odd (i.e.
False or TRUE). All rows that have 1 (odd rows) as a remainder get the
formatting.
--
Kevin Backmann


"susansbeach" wrote:

I have a "Rate Sheet" that is forwarded from Accounting Department that has
so much info on it, that I refer to on a regular basis. I would like to know
how to high-light every other line, because it makes it easier to read. It is
much too time consuming to do each line individually. Can anyone help?

How do I "highlight" every other line on a spread sheet?
 

hi
see this site
http://www.cpearson.com/excel/banding.htm

regards
FSt1

"susansbeach" wrote:

I have a "Rate Sheet" that is forwarded from Accounting Department that has
so much info on it, that I refer to on a regular basis. I would like to know
how to high-light every other line, because it makes it easier to read. It is
much too time consuming to do each line individually. Can anyone help?