Way to have rows automatically colour to separate data no matter how they sort?

  • Thread starter Thread starter Dylan56
  • Start date Start date
D

Dylan56

I was working on a document Friday at the office which had the
''=ROW()-1" command that keeps numbering the same even though data was
sorted.

It would be so helpful if I could add colour to the rows and despite
sorting, they remain dark, light, dark, light. I don't have a
document here to test this on, but is there a way to colour cells so
that the rows stay the same without shifting no matter what happens to
the data in each cell?? (i.e., when sorting, data gets moved).

Thank you!
 
Hi
one way:
- Select your cells
- goto 'Format - Conditional format'
- enter the following formula
=MOD(ROW(),2)=0 -> for coloring all even rows
or
=MOD(ROW(),2)=1 -> for coloring all odd rows
and choose your format
Frank
 
Dylan,

You need conditional formatting, a condition 1 of Is Formula Is, and a
formula of

=MOD(ROW(),m)=n

where you substitute the repeat pattern for m (that is how often for the
striped row, every 2nd, 3rd, 4th row etc), and the start strip row for n (1
for row 1, 2 for 2, etc.). n should be less than m.

Select a pattern colour (light green must be favourite), and you are away.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
one way:
- Select your cells
- goto 'Format - Conditional format'
- enter the following formula
=MOD(ROW(),2)=0 -> for coloring all even rows
or
=MOD(ROW(),2)=1 -> for coloring all odd rows
and choose your format
Frank
Click to expand...

That is excellent, thank you!! It works beautifully. Between your
instructions here and the webpage given in the other thread in this
post, I managed to colour the "even" rows a light blue. That is going
to be _such_ a tremendous help when I go have to go through the logs
we're creating using Excel!! I'm not so leery of the task now!

Cheers!

:oD
 
Back
Top