Highlighting every other row?
 

Is there a quick way to pick and highlight every other row in an excel
spreadsheet?

Highlighting every other row?
 

The free Excel add-in "Shade Data Rows"...
Download from... http://www.realezsites.com/bus/primitivesoftware
No registration required.
-or-
Use Conditional Formatting from the Format menu.
--
Jim Cone
San Francisco, USA


"Shanfrog"
wrote in message
Is there a quick way to pick and highlight every other row in an excel
spreadsheet?

Highlighting every other row?
 

See http://xldynamic.com/source/xld.CF.html#rows

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Shanfrog" wrote in message
...
Is there a quick way to pick and highlight every other row in an excel
spreadsheet?

Highlighting every other row?
 

higlight the section you want to colour every other row in and in conditional
formatting type

If formula is =MOD(ROW(),2)=0



"Shanfrog" wrote:

Is there a quick way to pick and highlight every other row in an excel
spreadsheet?