Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I auto shade every other line in a form already in use
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I auto shade every other line in a form already in use
Working with a copy of your file for practice.........you might try the
appropriate feature in the free add-in called ASAP Utilities. It's available at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "mbuet" wrote in message ... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I auto shade every other line in a form already in use
Select the range, then apply conditional formatting using the formula:
=MOD(ROW(),2) Choose a nice fill colour, ok out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mbuet" wrote in message ... How do I auto shade every other line in a form already in use |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I auto shade every other line in a form already in use
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I auto shade every other line in a form already in use
Thanks, Martin. Your reply to my post was the most informative and to the
point, with a lot of additional capablilities I will now use. Again, thanks! Michael B "MartinW" wrote: Hi, Take a look at this link. http://xldynamic.com/source/xld.CF.html#rows HTH Martin |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I auto shade every other line in a form already in use
Thanks for the feedback, but the thanks should go to Bob Phillips;
I'm just the messenger. Cheers Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shade under a line | Charts and Charting in Excel | |||
How do setup an auto fill form | Excel Discussion (Misc queries) | |||
Displaying data in bar form on a line chart | Charts and Charting in Excel | |||
auto numbering excell form | Excel Discussion (Misc queries) | |||
Let Excel shade every 3 line automatically | Excel Discussion (Misc queries) |