I'd like every second column to take on another color

  • Thread starter Thread starter Sulthon_NiShang
  • Start date Start date
I post the following solution last month for someone else, it may help
you too.


If you use conditional formatting, you can set up the following 3
conditions. All use the "Formula is" option.

Condition 1 =ISBLANK($A16) with No format set
Condition 2 =MOD(ROW(),2)=1 format this colour for ODD rows
Condition 3 =MOD(ROW(),2)=0 format this colour for EVEN rows

The purpose of the first condition is to leave blank rows un-coloured.

If you only want to colour ODD (or EVEN) rows whilst leaving the others
uncoloured you can use condition 1 and condition 2 (or 3)only.

If you don't mind about having blank rows being coloured then omit
condition 1.

Hope this helps

Mike
 
Select all cells, use Format/Conditonal Formatting, change "cell value is"
to "formula is", then enter =MOD(COLUMN(),2)=0, then click the Format
button, click the patterns tab, pick a color & OK your way out.
Bob Umlas
Excel MVP
 
Back
Top