Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make excell automatically select every other role for shadi
I have imported a large data table from a text file into excell. I want every
other role to be shaded to make it easier to read? How do I make excell shade every other role with out me having to manually select each role and then format one at a time. There has to be an easier way. Thanks |
#2
|
|||
|
|||
You can use conditional formatting
http://www.cpearson.com/excel/banding.htm Regards, Peo Sjoblom "How to select every other role?" wrote: I have imported a large data table from a text file into excell. I want every other role to be shaded to make it easier to read? How do I make excell shade every other role with out me having to manually select each role and then format one at a time. There has to be an easier way. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How do I make Excel automatically adjust a row's height once I in. | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
How to make Cells automatically become 'highlighted' when number . | Excel Worksheet Functions | |||
select unique to make list | Excel Worksheet Functions |