Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternate shading colors
I would like to alternate colors (white, yellow) for each row in my
spreadsheet. Do I have to create a table to do this? I want it to automatically know which color to add if I insert a row anywhere in the spreadsheet, and then adjust the rest of the rows automatically. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternate shading colors
Take a look at Chip Pearson's site:
http://cpearson.com/excel/banding.htm He uses format|conditional formatting to accomplish this. Another way (more manual, though) is to select your range then apply Format|Autoformat. You may have to reapply depending on what you change--but they have some pretty choices there. tjsmags wrote: I would like to alternate colors (white, yellow) for each row in my spreadsheet. Do I have to create a table to do this? I want it to automatically know which color to add if I insert a row anywhere in the spreadsheet, and then adjust the rest of the rows automatically. Is this possible? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternate shading colors
Hi,
With conditionnal formatting ... Choose Formula Is, use formula =MOD(ROW(),2)+1<=1 and Format with the pattern you want ... HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shading alternate rows, but losing format when one row is deleted | Excel Discussion (Misc queries) | |||
Alternate Shading | Excel Discussion (Misc queries) | |||
Display shading and font colors in edit mode | Excel Discussion (Misc queries) | |||
How can I alternate row colors in Excel and keep the effect? | Excel Discussion (Misc queries) | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) |