Background

  • Thread starter Thread starter Leif
  • Start date Start date
L

Leif

Hi,
is there possible to make a background pattern where, say every second row
in the whole sheet is gray, and the background remains uneffected when I
sort, delete or insert rows?

Best regards
Leif
 
Hi Leif
1. highlight the desired rows
2. Goto 'Format - Conditional Format'
3. Choose formula and enter the following
=MOD(ROW(),2) -> this will color all odd rows
=MOD(ROW(),2)=1 -> colors all even rows
4. choose your desired format

HTH
Frank
 
Hi Frank,
Actually both of your formulas are equivalent in this context and will
result in formatting odd rows. The purpose of the Conditional Formatting
formula is to return either TRUE (not zero), or FALSE (zero).

To format the even rows use
=MOD(ROW(),2)=0
or
=NOT(MOD(ROW(),2)

The reference to Chip Pearson's site mentioned by Leif, helps set
up variations such as banding rows together (3 green, 3 default) and
whether to start with or without the banding. I would generally start
without banding so rows with titles at top don't have color.
 
Back
Top