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 |
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 |
All times are GMT +1. The time now is 02:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com