Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I tell excel to highlight every 4 rows?
I need to highlight every 4 rows in my spreadsheet. How do I do this? I
have 21000 rows to sort through. :( |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I tell excel to highlight every 4 rows?
One way
Sub HI() For I = 1 To 21000 Step 4 Rows(I).Interior.ColorIndex = 6 Next I End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Amanda" wrote in message ... I need to highlight every 4 rows in my spreadsheet. How do I do this? I have 21000 rows to sort through. :( |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I tell excel to highlight every 4 rows?
On May 23, 7:58*am, Amanda wrote:
I need to highlight every 4 rows in my spreadsheet. *How do I do this? *I have 21000 rows to sort through. *:( Can also be done using conditional formatting with... Formula Is =MOD(INT((ROW(1:1)-1)/4),2)=0 which applies the chosen highlight colour to the 1st to 4th, 9th to 12th etc rows in the cells that were selected before the conditional formatting was applied,OR... Formula Is =MOD(INT((ROW(1:1)-1)/4),2)=1 which applies the chosen highlight colour to the 5th to 8th, 13th to 16th etc rows in the cells that were selected before the conditional formatting was applied. Ken Johnson .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight rows | Excel Worksheet Functions | |||
[VBA] How to highlight rows in PivotTable | Excel Worksheet Functions | |||
Formatting to highlight rows | Excel Discussion (Misc queries) | |||
Can I highlight all the odd rows in Excel? | Excel Discussion (Misc queries) | |||
Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions |