colour rows alternating colour

[Grd]

Hi there,

I'd like to create a conditional formatting formula to colour my rows yellow
and white.
Is this possible?

Any help greatly appreciated

Thanks
Suzanne

 

[JW]

Highlight the range where you want this to happen and select Format--

Conditional Formatting. Select Formula Is from the drop down and

place one of the the formulas below in the field. Make your necessary
formatting changes.
This will format all of the even rows:
=MOD(ROW(),2)=0
This will format all of the odd rows:
=MOD(ROW(),2)

 

[Gary''s Student]

Pick a cell and conditional format:

Formula Is:

=MOD(ROW(),2)=1 and pick yellow

Then copy the cell and paste/special/formats over the cells of interest.

 

[Bob Phillips]

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)

 

[Grd]

wow

tx
s

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)

 

[Grd]

works great

Tx

Pick a cell and conditional format:

Formula Is:

=MOD(ROW(),2)=1 and pick yellow

Then copy the cell and paste/special/formats over the cells of interest.

 

[Grd]

works thanks

Highlight the range where you want this to happen and select Format--
place one of the the formulas below in the field. Make your necessary
formatting changes.
This will format all of the even rows:
=MOD(ROW(),2)=0
This will format all of the odd rows:
=MOD(ROW(),2)