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

http://office.microsoft.com/en-us/ex...CL100570551033

but do not know how to apply this.

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.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111004

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

If this post helps click Yes
---------------
Jacob Skaria


"DJTrainer76" wrote:

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

http://office.microsoft.com/en-us/ex...CL100570551033

but do not know how to apply this.