About Us

mgm[_3_]

Thanks guys.... just what I needed!
"Peter M" wrote in message
...
Bob, Frank,

Many thanks - I'll delete my 'the easiest way' and replace with 'nearly
the
easiest way'!

I didn't realise that that would work - clearly a philosophy to employ
elsewhere.

Thanks.

Peter

"Frank Kabel" wrote in message
...
Hi Peter
this can be shortened to
=MOD(ROW(),2)=1

see also
http://www.cpearson.com/excel/banding.htm
for more general formulas
Frank

Peter M wrote:
MGM

The easiest way of achieving this is to use the conditional formating
facility. Firstly select all the cells that you want the formating
to apply too. Then on the worksheet menu bar select Format,
Conditional Format.

In the left hand dropdown box choose 'Formula Is' rather than the
default 'Cell Value Is'. In the edit box that then appears enter:

=IF(MOD(ROW(),2)=1,TRUE,FALSE)

Then click on the 'Format' button and set the Pattern style to grey
(or whatever other colour you fancy).

If you want a wider spacing between highlighted lines simply change
the number in the formula above, for example:

=IF(MOD(ROW(),5)=1,TRUE,FALSE) highlights every 5th row.

This is much easier than using VB.

Hope it works for you!

Peter Morris
"mgm" wrote in message
...
I would like to have my spreadsheets to have rows that have a
color/grey alternate to make reading the data clearer and easier to
follow. Is there a way to write a macro or vba that could be
triggered and accessed by all my workbooks?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting Alternating Rows with a Color	Daren	Excel Worksheet Functions	8	September 30th 08 10:19 PM
Alternating Color Rows	Gator	Excel Discussion (Misc queries)	1	June 18th 08 05:42 PM
Make text color match cell color with macro?	JoeSpareBedroom	Excel Discussion (Misc queries)	1	June 26th 07 07:09 PM
How do I set an auto alternating row color?	Daniel Stephens	Excel Discussion (Misc queries)	2	July 19th 05 05:22 PM
Filling alternating rows in a worksheet with color backgroud	Tom L[_2_]	Excel Programming	1	October 30th 03 10:52 PM

Menu

About Us