Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alternate Color Lines when using Custom Views
Hello Everyone,
I used the following code in the Conditional Fomatting dialog box to acheive alternate colour lines: =MOD(ROW(),2)=1 This works fine, except when I choose a custom view, the alternate lines do not re-color themselves and I get blocks of one color or another - looks messy... Does anyone know how to fix this? Thanks |
#2
|
|||
|
|||
Alternate Color Lines when using Custom Views
What is the custom view doing specifically?
-- HTH RP (remove nothere from the email address if mailing direct) "GLT" wrote in message ... Hello Everyone, I used the following code in the Conditional Fomatting dialog box to acheive alternate colour lines: =MOD(ROW(),2)=1 This works fine, except when I choose a custom view, the alternate lines do not re-color themselves and I get blocks of one color or another - looks messy... Does anyone know how to fix this? Thanks |
#3
|
|||
|
|||
Alternate Color Lines when using Custom Views
Hi Bob,
Thanks for your response - I have autofilter switched on for the columns and I have saved a few different filters as a custom view... Whenever I select a custom view and the data is filtered, the color lines are based from the original view... Cheers "Bob Phillips" wrote: What is the custom view doing specifically? -- HTH RP (remove nothere from the email address if mailing direct) "GLT" wrote in message ... Hello Everyone, I used the following code in the Conditional Fomatting dialog box to acheive alternate colour lines: =MOD(ROW(),2)=1 This works fine, except when I choose a custom view, the alternate lines do not re-color themselves and I get blocks of one color or another - looks messy... Does anyone know how to fix this? Thanks |
#4
|
|||
|
|||
Alternate Color Lines when using Custom Views
Could it be because although the autofilter is hiding some rows, the MOD
function does not ignore them. Maybe this formula will work better =MOD(SUBTOTAL(3,$A$1:$A1),2)=1 -- HTH RP (remove nothere from the email address if mailing direct) "GLT" wrote in message ... Hi Bob, Thanks for your response - I have autofilter switched on for the columns and I have saved a few different filters as a custom view... Whenever I select a custom view and the data is filtered, the color lines are based from the original view... Cheers "Bob Phillips" wrote: What is the custom view doing specifically? -- HTH RP (remove nothere from the email address if mailing direct) "GLT" wrote in message ... Hello Everyone, I used the following code in the Conditional Fomatting dialog box to acheive alternate colour lines: =MOD(ROW(),2)=1 This works fine, except when I choose a custom view, the alternate lines do not re-color themselves and I get blocks of one color or another - looks messy... Does anyone know how to fix this? Thanks |
#5
|
|||
|
|||
Alternate Color Lines when using Custom Views
If it acts like filtering and you have all cells
=MOD(SUBTOTAL(3,$A$1:$A1),2) for alternate row banding requires all cells in column A to be used in the rows not hidden by filtering.. http://www.mvps.org/dmcritchie/excel....htm#colorband Should be simple for you to test, I don't know what view actually does. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "GLT" wrote in message ... Hello Everyone, I used the following code in the Conditional Fomatting dialog box to acheive alternate colour lines: =MOD(ROW(),2)=1 This works fine, except when I choose a custom view, the alternate lines do not re-color themselves and I get blocks of one color or another - looks messy... Does anyone know how to fix this? Thanks |
#6
|
|||
|
|||
Alternate Color Lines when using Custom Views
Sorry Bob, I overlooked your reply, in fact I missed that view
was autofilter so was unsure of my answer then. |
#7
|
|||
|
|||
Alternate Color Lines when using Custom Views
No problem David, it never hurts, especially with the problems people
sometimes get with not seeing some posts. Regards Bob "David McRitchie" wrote in message ... Sorry Bob, I overlooked your reply, in fact I missed that view was autofilter so was unsure of my answer then. |
#8
|
|||
|
|||
Alternate Color Lines when using Custom Views
Thanks Bob that works great :)
"Bob Phillips" wrote: No problem David, it never hurts, especially with the problems people sometimes get with not seeing some posts. Regards Bob "David McRitchie" wrote in message ... Sorry Bob, I overlooked your reply, in fact I missed that view was autofilter so was unsure of my answer then. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get custom views created in Excel 2K to show in Excel 200 | Excel Worksheet Functions | |||
Custom Views in Shared workbook | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Custom Views in Pivot Table | Excel Discussion (Misc queries) | |||
Can I set my custom views on Pivot table | Excel Discussion (Misc queries) |