conditional formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ruth - 15 Mar 2008 00:37 GMT

Hi there

I am created a file to keep track of marks. I want every other line to have
the back ground fill in. Sometimes students names will be added or deleted.
I don't want to have to change the format for each line when a student is
added or deleted. Is there a way to do this?

Signature

Thank-you!
Ruth

Reply to this Message

David Biddulph - 15 Mar 2008 01:16 GMT

CF/ Formula Is ...
=MOD(ROW(),2)
--
David Biddulph

> Hi there
>
[quoted text clipped - 4 lines]
> I don't want to have to change the format for each line when a student is
> added or deleted. Is there a way to do this?

Reply to this Message

FSt1 - 15 Mar 2008 01:21 GMT

hi
you can use conditional formating to do that. it's called banding.
see this site for detailed instructions.
http://www.cpearson.com/excel/banding.htm

Regards
FSt1

> Hi there
>
> I am created a file to keep track of marks. I want every other line to have
> the back ground fill in. Sometimes students names will be added or deleted.
> I don't want to have to change the format for each line when a student is
> added or deleted. Is there a way to do this?

Reply to this Message

Ruth - 15 Mar 2008 17:26 GMT

Thank-you very much!

Signature

Thank-you!
Ruth

> hi
> you can use conditional formating to do that. it's called banding.
[quoted text clipped - 10 lines]
> > I don't want to have to change the format for each line when a student is
> > added or deleted. Is there a way to do this?

Reply to this Message