Question about autocoloring cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zerex71 - 17 Jul 2006 15:56 GMT

Hi all,

I have a question about autocoloring cells, rows, columns, etc. This
is not about conditional formatting - it's about, for example, coloring
every other row automatically per some function or style setup.

The example I have is a row-based database of recruiters. As my
contacts list grows and shrinks, I have been having to manually recolor
every other row light blue for visibility purposes. Not that much of a
hassle but (a) I'd prefer not to do it and (b) if Excel has a way to do
it for me, so much the better, I learn a new feature of Excel. Is
there a way that Excel can auto-recalculate row colors as I expand or
contract my spreadsheet?

Mike

Reply to this Message

MartinW - 17 Jul 2006 16:14 GMT

Hi Mike,

You say it's not about conditional formatting but you might find
this site interesting. It takes conditional formatting to a new level.

http://xldynamic.com/source/xld.CF.html#lights

HTH
Martin

Reply to this Message

Bobbie - 17 Jul 2006 18:10 GMT

This is the one I use all the time. When you add additonal rows or
delete rows it automatically adjusts the row color.

=MOD(ROW(),2)=0

I even use a second condition =MOD(ROW(),1)=0 when I want two colors.
Select your area and go to conditional formatting and change the
condition to Formula is: and copy the formula above. I think you will
find a lot of use for this funciton.

Bobbie

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Mike

Reply to this Message

Bob Phillips - 17 Jul 2006 19:05 GMT

That is exactly conditional formatting. See
http://xldynamic.com/source/xld.CF.html#rows

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Mike

Reply to this Message

Traveller - 17 Jul 2006 20:27 GMT

If I understand your question correctly, all you want is a fairly simple way
to add color to every other row in your database list, without having to
manually do it one row at a time. This can be done very simply with the
Format Painter button. Add color to one row, then highlight two adjacent
rows, one with color and one without. Click on the Format Painter button,
then drag down the left hand margin of your entire list while holding down
the mouse button. Release the mouse button when you get to the bottom, and
the job is done! The Format Painter is a real time saver.

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Mike

Reply to this Message

Zerex71 - 18 Jul 2006 03:27 GMT

Thanks to everyone who wrote, that worked like a champ!

Mike

> If I understand your question correctly, all you want is a fairly simple way
> to add color to every other row in your database list, without having to
[quoted text clipped - 20 lines]
> >
> > Mike

Reply to this Message

Rate this thread: