| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternate Background-colors
Hi I have a really big excel sheet with more than 20000 rows. I would like to set the background color alternate every 150 rows. means: the first 150 rows blue background, the next 150 rows green background, the next 150 rows blue background again and so on. How can i do that autmatically? Cheers Sissi -- sissi ------------------------------------------------------------------------ sissi's Profile: http://www.excelforum.com/member.php...o&userid=37820 View this thread: http://www.excelforum.com/showthread...hreadid=573781 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alternate Background-colors
Use conditional formatting and place these formulas in the first condition =MOD((ROW()-MOD(ROW(),150))/150,2)=0 and format blue second condition =MOD((ROW()-MOD(ROW(),150))/150,2)<0 and format green. sissi Wrote: Hi I have a really big excel sheet with more than 20000 rows. I would like to set the background color alternate every 150 rows. means: the first 150 rows blue background, the next 150 rows green background, the next 150 rows blue background again and so on. How can i do that autmatically? Cheers Sissi -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=573781 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I alternate row colors in Excel and keep the effect? | Excel Discussion (Misc queries) | |||
| Background colors are printed but not shown in normal vieuw | Excel Discussion (Misc queries) | |||
| In excel, importing from anouther sheet background colors will no. | Excel Worksheet Functions | |||
| How do I change background colors between secondary y axis lines? | Charts and Charting in Excel | |||
| Excel Cell Background Colors Disappeared | Excel Discussion (Misc queries) | |||
Linear Mode
