Color banding

[DJTrainer76]

How do I apply color banding in a spreadsheet? I see how it is used here

http://office.microsoft.com/en-us/excel/HA011366231033.aspx?pid=CL100570551033

but do not know how to apply this.

 

[NBVC]

Right-click on the worksheet tab you want it to apply to and select
"View Code"

Copy and paste the code from your link into the white editor window.

Close the editor.

Now test on your sheet.

 

[Jacob Skaria]

Also dont forget to set the Security level to low/medium in
(Tools|Macro|Security).

If this post helps click Yes