| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Shading
How do I keep every other row shaded when I sort data?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Shading
see posting on this topic, earlier today.
select the rows you want shaded. go to conditional formatting. formula....=mod(row(),2) and select the shading color you want. "viper2000ss" wrote: How do I keep every other row shaded when I sort data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| How can I unblock the printing of cell shading? | Excel Discussion (Misc queries) | |||
Hybrid Mode
