| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to highlight alternate rows
Hi,
I have a book of Excel formulas that gives the following formula to shade alternate rows in a Workbook: i.e. so the rows look grey, white, grey, white, etc. =MOD(ROW( ),2)=0 Does anyone know if there's an error somewhere because I can't get it to work. I typed it in the formula line...Maybe I'm supposed to enter a range somewhere...not sure. Thanks. |
|
#2
|
|||
|
|||
|
You need to use conditional formatting and formula is under
formatconditional formatting http://www.cpearson.com/excel/banding.htm Regards, Peo Sjoblom "Brenda" wrote: Hi, I have a book of Excel formulas that gives the following formula to shade alternate rows in a Workbook: i.e. so the rows look grey, white, grey, white, etc. =MOD(ROW( ),2)=0 Does anyone know if there's an error somewhere because I can't get it to work. I typed it in the formula line...Maybe I'm supposed to enter a range somewhere...not sure. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
| Use of Exact(or other) function for alternate rows? | Excel Worksheet Functions | |||
| Identifying exact values in alternate rows | Excel Worksheet Functions | |||
Linear Mode
