| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zebra stripe format filtered case as well
Hi,
I learned in "msexcelraj website (could not see a name to mention here to thank)" how to make zebra stripe formating: Conditional formating, mod(row(),2)=0). My additional question is "how can I have zebra appearence when I make filtering as well ?" When I filter, naturally zebra appearence is losing with the way above. Thanks and regards, Cousin Excel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zebra stripe format filtered case as well
Hi,
Select the range then format|Conditional format-Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Pick a colour ADD Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=1 Pick another colour OK -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "CousinExcel" wrote: Hi, I learned in "msexcelraj website (could not see a name to mention here to thank)" how to make zebra stripe formating: Conditional formating, mod(row(),2)=0). My additional question is "how can I have zebra appearence when I make filtering as well ?" When I filter, naturally zebra appearence is losing with the way above. Thanks and regards, Cousin Excel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zebra stripe format filtered case as well
Hi Master Mike,
I could not find where I could making mistake. I' m doing - conditional formating - use a formula to determine which cells to.. - write your formulas =MOD(SUBTOTAL(3;$A$1:$A$5);2)=0 format ... - new rule =MOD(SUBTOTAL(3;$A$1:$A$5);2)=1 format but all cells are color 2 (mod..= 1 color.) Thanks and regards, Cousin Excel "Mike H" wrote: Hi, Select the range then format|Conditional format-Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Pick a colour ADD Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=1 Pick another colour OK -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "CousinExcel" wrote: Hi, I learned in "msexcelraj website (could not see a name to mention here to thank)" how to make zebra stripe formating: Conditional formating, mod(row(),2)=0). My additional question is "how can I have zebra appearence when I make filtering as well ?" When I filter, naturally zebra appearence is losing with the way above. Thanks and regards, Cousin Excel |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zebra stripe format filtered case as well
Mike typed an extra $ sign in his formula.
Try this after selecting a great whack of rows. =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 You will get your color band alternating with default color. Gord Dibben MS Excel MVP On Fri, 5 Feb 2010 22:53:01 -0800, CousinExcel wrote: Hi Master Mike, I could not find where I could making mistake. I' m doing - conditional formating - use a formula to determine which cells to.. - write your formulas =MOD(SUBTOTAL(3;$A$1:$A$5);2)=0 format ... - new rule =MOD(SUBTOTAL(3;$A$1:$A$5);2)=1 format but all cells are color 2 (mod..= 1 color.) Thanks and regards, Cousin Excel "Mike H" wrote: Hi, Select the range then format|Conditional format-Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Pick a colour ADD Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=1 Pick another colour OK -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "CousinExcel" wrote: Hi, I learned in "msexcelraj website (could not see a name to mention here to thank)" how to make zebra stripe formating: Conditional formating, mod(row(),2)=0). My additional question is "how can I have zebra appearence when I make filtering as well ?" When I filter, naturally zebra appearence is losing with the way above. Thanks and regards, Cousin Excel |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zebra stripe format filtered case as well
Thank you very much.
It helped a lot. (In fact I had tried the same logic but I must have made a mistake and it did not work). Thanks and regards, Cousin Excel "Gord Dibben" wrote: Mike typed an extra $ sign in his formula. Try this after selecting a great whack of rows. =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 You will get your color band alternating with default color. Gord Dibben MS Excel MVP On Fri, 5 Feb 2010 22:53:01 -0800, CousinExcel wrote: Hi Master Mike, I could not find where I could making mistake. I' m doing - conditional formating - use a formula to determine which cells to.. - write your formulas =MOD(SUBTOTAL(3;$A$1:$A$5);2)=0 format ... - new rule =MOD(SUBTOTAL(3;$A$1:$A$5);2)=1 format but all cells are color 2 (mod..= 1 color.) Thanks and regards, Cousin Excel "Mike H" wrote: Hi, Select the range then format|Conditional format-Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Pick a colour ADD Formula is =MOD(SUBTOTAL(3,$A1:$A$2),2)=1 Pick another colour OK -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "CousinExcel" wrote: Hi, I learned in "msexcelraj website (could not see a name to mention here to thank)" how to make zebra stripe formating: Conditional formating, mod(row(),2)=0). My additional question is "how can I have zebra appearence when I make filtering as well ?" When I filter, naturally zebra appearence is losing with the way above. Thanks and regards, Cousin Excel . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stripe out duplicate data | Excel Worksheet Functions | |||
| Format cell to convert to Upper case | Excel Discussion (Misc queries) | |||
| What happened to the stripe fills for data series in Excel 2007? | Charts and Charting in Excel | |||
| Format Case for only | Excel Discussion (Misc queries) | |||
| Upper Case and date format issue | Excel Discussion (Misc queries) | |||
Hybrid Mode
