Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting every other row?
Is there a quick way to pick and highlight every other row in an excel
spreadsheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
HIGHLIGHTING | Excel Worksheet Functions | |||
Mouse highlighting cells error | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Cells in Excel will not stop highlighting | Excel Discussion (Misc queries) |