Is there some way to format with the following " =MOD(ROW9(),2)=0" as you
could in excel office XP Pro. I want to format a range with two colors
alternating throughout the range.

See http://www.xldynamic.com/source/xld.CF.html\rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inquisitive" wrote in message
...
Is there some way to format with the following " =MOD(ROW9(),2)=0" as you
could in excel office XP Pro. I want to format a range with two colors
alternating throughout the range.

Sorry, mis character

http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inquisitive" wrote in message
...
Is there some way to format with the following " =MOD(ROW9(),2)=0" as you
could in excel office XP Pro. I want to format a range with two colors
alternating throughout the range.

Bob, First let me thank you for the quick reply. The one thing I forgot to
state in my cry for help is the fact that I am now using excel 2007. The
information that you provided is exactly what I am looking for but unable to
find in the 2007 version.

Robert
--
in-doubt


"Bob Phillips" wrote:

Sorry, mis character

http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inquisitive" wrote in message
...
Is there some way to format with the following " =MOD(ROW9(),2)=0" as you
could in excel office XP Pro. I want to format a range with two colors
alternating throughout the range.

http://office.microsoft.com/en-us/ex...491511033.aspx gives a guide as
to where in Excel 2007 you can find the equivalent of Excel 2003 commands.
--
David Biddulph

"inquisitive" wrote in message
...
Bob, First let me thank you for the quick reply. The one thing I forgot to
state in my cry for help is the fact that I am now using excel 2007. The
information that you provided is exactly what I am looking for but unable
to
find in the 2007 version.

Robert
--
in-doubt


"Bob Phillips" wrote:

Sorry, mis character

http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"inquisitive" wrote in message
...
Is there some way to format with the following " =MOD(ROW9(),2)=0" as
you
could in excel office XP Pro. I want to format a range with two colors
alternating throughout the range.

It is in the Home Tab, first item in the Styles group

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"inquisitive" wrote in message
...
Bob, First let me thank you for the quick reply. The one thing I forgot to
state in my cry for help is the fact that I am now using excel 2007. The
information that you provided is exactly what I am looking for but unable
to
find in the 2007 version.

Robert
--
in-doubt


"Bob Phillips" wrote:

Sorry, mis character

http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"inquisitive" wrote in message
...
Is there some way to format with the following " =MOD(ROW9(),2)=0" as
you
could in excel office XP Pro. I want to format a range with two colors
alternating throughout the range.