Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set an auto alternating row color?
I'd like to set my excel database ROWS to alternating colors(ex. teal &
white). My database is HUGE and I can't feasibly do it manually without taking hours and hours clicking each row and changing the color. Also another concern is that I constantly am adding rows throughout the database. I'd like to know if there's a way to automatically have to row colors stay alternating. Thanks a ton! Daniel |
#2
|
|||
|
|||
Daniel,
Select all your cell, the use Format / Conditional Formatting... Formula is... and use the formula =MOD(ROW(),2)=0 (for the first row to not be shaded) or =MOD(ROW(),2)=1 (for the first row to be shaded) and set your color as you want by clicking the Format button, and selecting your fill color on the patterns tab. Then click OK OK and you're done. HTH, Bernie MS Excel MVP "Daniel Stephens" <Daniel wrote in message ... I'd like to set my excel database ROWS to alternating colors(ex. teal & white). My database is HUGE and I can't feasibly do it manually without taking hours and hours clicking each row and changing the color. Also another concern is that I constantly am adding rows throughout the database. I'd like to know if there's a way to automatically have to row colors stay alternating. Thanks a ton! Daniel |
#3
|
|||
|
|||
Thank you SO much. That was very very helpful.
"Bernie Deitrick" wrote: Daniel, Select all your cell, the use Format / Conditional Formatting... Formula is... and use the formula =MOD(ROW(),2)=0 (for the first row to not be shaded) or =MOD(ROW(),2)=1 (for the first row to be shaded) and set your color as you want by clicking the Format button, and selecting your fill color on the patterns tab. Then click OK OK and you're done. HTH, Bernie MS Excel MVP "Daniel Stephens" <Daniel wrote in message ... I'd like to set my excel database ROWS to alternating colors(ex. teal & white). My database is HUGE and I can't feasibly do it manually without taking hours and hours clicking each row and changing the color. Also another concern is that I constantly am adding rows throughout the database. I'd like to know if there's a way to automatically have to row colors stay alternating. Thanks a ton! Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill color change | Excel Discussion (Misc queries) | |||
Auto color change | Excel Discussion (Misc queries) | |||
Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions | |||
Auto color change to tabs in worksheet | Excel Worksheet Functions |