| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help Wth Cell shading
Looking at a large spread sheet full of data can become hard on the eyes.
Is there a way to alternate the colors or shading of each row permanenatly so the shading does not move or change once the rows of data are moved or sorted ? Many thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please Help Wth Cell shading
Hi Joe,
Use conditional formatting with a formula condition like: =MOD(ROW(),2)=0 --- Regards, Norman "Joe who?" wrote in message news:_kL_e.280372$Hk.96115@pd7tw1no... Looking at a large spread sheet full of data can become hard on the eyes. Is there a way to alternate the colors or shading of each row permanenatly so the shading does not move or change once the rows of data are moved or sorted ? Many thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Please Help Wth Cell shading
That's great Norman, I'll give it a try. thanks for the help !
"Norman Jones" wrote in message ... Hi Joe, Use conditional formatting with a formula condition like: =MOD(ROW(),2)=0 --- Regards, Norman "Joe who?" wrote in message news:_kL_e.280372$Hk.96115@pd7tw1no... Looking at a large spread sheet full of data can become hard on the eyes. Is there a way to alternate the colors or shading of each row permanenatly so the shading does not move or change once the rows of data are moved or sorted ? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| cell shading | Excel Discussion (Misc queries) | |||
Hybrid Mode
