| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I use conditional formatting for alternating cell shading?
Hi!
If you want to shade the odd rows: =MOD(ROW(),2)=1 If you want to shade the even rows: =MOD(ROW(),2)=0 Biff "Exceluser" wrote in message ... I need to alternate cell shading based on the row number(even, odd). I need to know how to do this using the MOD with the Row function as argument. I am using Excel in Office XP version 2002. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting if any value in the cell | Excel Worksheet Functions | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting | Excel Worksheet Functions | |||
Hybrid Mode
