Question about autocoloring cells?

Z

Zerex71

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
 
B

Bobbie

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
 
T

Traveller

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.
 
Top