CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.