Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring cells
I want to alternate colors between successive rows. One blue one white, the
next one blue and the next white and so on to the end of my worksheet. It there a easier way than to hold the control key and click on each row? Question # 2 when I sort will the colors stay with the row or will they move with the sort. Is there a way to get the colors to stay even when I sort? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring cells
You can use conditional formatting which applies the colour using the Mod()
function: http://www.ozgrid.com/Excel/alternate-row-color.htm After sorting, every second row remains the same colour as before sorting. Aaron Blood has a Ledger Shade addin http://www.xl-logic.com/modules.php?...download&cid=3 You may need to join. -- Steve "6371" wrote in message ... I want to alternate colors between successive rows. One blue one white, the next one blue and the next white and so on to the end of my worksheet. It there a easier way than to hold the control key and click on each row? Question # 2 when I sort will the colors stay with the row or will they move with the sort. Is there a way to get the colors to stay even when I sort? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring cells
Select a gaggle of rows(not cells) the FormatConditional Formatting
Formula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Pick your blue color and OK Alternate row shading will survive sorting and filtering. Or this version which will not shade blanks rows below your actual data. =AND(MOD(SUBTOTAL(3,$A1:$A$2),2)=0,COUNTA(ROW())0 ) Gord Dibben MS Excel MVP On Tue, 21 Apr 2009 16:58:01 -0700, 6371 wrote: I want to alternate colors between successive rows. One blue one white, the next one blue and the next white and so on to the end of my worksheet. It there a easier way than to hold the control key and click on each row? Question # 2 when I sort will the colors stay with the row or will they move with the sort. Is there a way to get the colors to stay even when I sort? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for coloring in cells | Excel Discussion (Misc queries) | |||
coloring cells | Excel Discussion (Misc queries) | |||
COLORING IN CELLS | Excel Discussion (Misc queries) | |||
Coloring certain cells | Excel Worksheet Functions | |||
Coloring Cells | Excel Worksheet Functions |