alternating colors
 

How do I create a spreadsheet with alternating colors by column and by row.
Ex: I want the rows to be green and white by line to make it easier to read.
But I also want columns H-O alternate a different color lengthwise. I was
able to get the rows to alternate colors but can't figure out how to also get
the specific columns to alternate colors.

Thanks

alternating colors
 

I selected row headers 1:10 and use Conditional Formatting with Formula is
=MOD(ROW(),2)=0 and used a patter of green
This make every other row green
Then I selected column H1:O10 and added a second Condition
=MOD(COLUMN(),2)=0 and set colour to pink
In row 1 all cells are white except H1, J1, K1, and N1
In row 2 all cells are green
You could make some 'fancy' conditions like
=AND(MOD(ROW(),2)=0,=MOD(COLUMN(),2)=0) to make a patchwork

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bobblehead86" wrote in message
...
How do I create a spreadsheet with alternating colors by column and by
row.
Ex: I want the rows to be green and white by line to make it easier to
read.
But I also want columns H-O alternate a different color lengthwise. I
was
able to get the rows to alternate colors but can't figure out how to also
get
the specific columns to alternate colors.

Thanks