Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color Alternate Rows
Try this conditional format formula, taken from a post by Tom Ogilvy,
http://tinyurl.com/dsu87 " If the hidden rows are cause by applying a filter then this formula will work: =MOD(SUBTOTAL(3,$A$1:A1),2)=0 Select the rows to format (this assumes the formatting starts with row 1) Enter the formula as if it were for the the currently active cell (in this case A1). The range must be applied to a column that will contain values in each visible cell in the column. " The formula above will also take care of the normal unfiltered situation -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Conditional Format Issue" wrote: I'm filtering results of a table and want to have alternating rows filled with a color even as I'm filtering and unfiltering results. In other words, I want alternating colors no matter which rows are in view at any given point. Any ideas? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum alternate rows | Excel Worksheet Functions | |||
How to calculate the sum of the alternate rows? | Excel Worksheet Functions | |||
Alternate Color Lines when using Custom Views | Excel Discussion (Misc queries) | |||
Add alternate rows | Excel Worksheet Functions | |||
How to sum-up alternate rows ? | Excel Worksheet Functions |