Stripey Spreadsheet Macro/VB script 1

[dom747]

Is it possible to create a Macro in Excel 2000 to produce a striped spreadsheet (eg. first row yellow, second row white, third row yellow) without reformatting the cells and only for the areas in the spreadsheet where data has been enetered ?

 

[schu]

try

Sub Macro1()
For i = 1 To 100 Step 2
Rows(i).Select
With Selection.Interior
.Color = RGB(255, 0, 0)
.Pattern = xlSolid
End With
Next i
End Sub

The color is specified by the RGB call.
You can modify the selection range i.e. rows(..).select to
control the area you want to highlight.

 

[mymou]

Hi dom747


Use conditional formating

"formula is" set to:
=(MOD(ROW(),2)=0)
(dont forget to change formatting for when it is true)

Then, just record a macro.


Stew

"Even a stopped clock tells the right time twice a day."