| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting rows
Hello all,
Can anyone tell me how to shade every other rows. There must be a way so that one row is non shaded and the other is without me having to do them all manually. If it is a formula, please provide it : i go nutts doing those. Thank you so much, happy new year! Louise |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting rows
Check out chip Pearson's site: http://cpearson.com/excel/banding.htm
-- Hth Kassie Kasselman "Louise B." wrote: Hello all, Can anyone tell me how to shade every other rows. There must be a way so that one row is non shaded and the other is without me having to do them all manually. If it is a formula, please provide it : i go nutts doing those. Thank you so much, happy new year! Louise |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting rows
Hi,
Use this in conditional formatting: =MOD(ROW(),2)=1 or =MOD(ROW(),2)=0 depending on which row you want formatted, 1 for odd numbered rows and 0 for even numbered. HTH Jean-Guy "Louise B." wrote: Hello all, Can anyone tell me how to shade every other rows. There must be a way so that one row is non shaded and the other is without me having to do them all manually. If it is a formula, please provide it : i go nutts doing those. Thank you so much, happy new year! Louise |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting rows
Thanks to both of you. Still I get an error message saying that there is a
error in the formula and it pinpoints the ,2 in the formula. Any idea what goes wrong? Thanks again "Louise B." wrote: Hello all, Can anyone tell me how to shade every other rows. There must be a way so that one row is non shaded and the other is without me having to do them all manually. If it is a formula, please provide it : i go nutts doing those. Thank you so much, happy new year! Louise |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting rows
Lots of non-USA users have a list separator of ; (semicolon) instead of a ,
(comma). You may want to try that. Louise B. wrote: Thanks to both of you. Still I get an error message saying that there is a error in the formula and it pinpoints the ,2 in the formula. Any idea what goes wrong? Thanks again "Louise B." wrote: Hello all, Can anyone tell me how to shade every other rows. There must be a way so that one row is non shaded and the other is without me having to do them all manually. If it is a formula, please provide it : i go nutts doing those. Thank you so much, happy new year! Louise -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use conditional formatting to hide or delete rows? | Excel Worksheet Functions | |||
| Conditional Formatting for rows... | Excel Discussion (Misc queries) | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
Linear Mode
