Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change colour of rows in a worksheet
How can I change each nth row's colour in a worksheet?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change colour of rows in a worksheet
Use Conditional Formatting.
Following formula would set your desired color to the every 7th row . =mod(row(),7)=0 "VJ Sharma" wrote: How can I change each nth row's colour in a worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change default worksheet colour from white? | Excel Discussion (Misc queries) | |||
how do i change (or add) colour to the worksheet tabs (in excel) | Excel Worksheet Functions | |||
Change colour of worksheet tabs in Excel | Excel Discussion (Misc queries) | |||
Formula to change rows a different colour? | Excel Worksheet Functions | |||
Change Font colour mid-worksheet: Excel 2003 | Excel Discussion (Misc queries) |