Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternating format | Excel Discussion (Misc queries) | |||
How do I create alternating row colors in excel? | Excel Discussion (Misc queries) | |||
Alternating BG colors between groups of rows | Excel Discussion (Misc queries) | |||
Alternating Margins | Excel Discussion (Misc queries) | |||
Alternating colors for rows | Excel Discussion (Misc queries) |