Lets say I want color banding for cells

column A to F
Row 27 to 226

what should be the formula....

Please advise.

Thanks.
Mukesh

See http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mukesh" <(E-Mail Removed)> wrote in message
news2D37F96-E924-42BA-B8B4-(E-Mail Removed)...
> Lets say I want color banding for cells
>
> column A to F
> Row 27 to 226
>
> what should be the formula....
>
> Please advise.
>
> Thanks.
> Mukesh
>

The following website has complete instructions on creating a banded worksheet.

http://www.contextures.com/xlCondFormat03.html#Bands
--
Kevin Backmann


"Mukesh" wrote:

> Lets say I want color banding for cells
>
> column A to F
> Row 27 to 226
>
> what should be the formula....
>
> Please advise.
>
> Thanks.
> Mukesh
>

Thank you Bob,
that was way too simple & easy!

Thanks.
Mukesh



"Bob Phillips" wrote:

> See http://www.xldynamic.com/source/xld.CF.html#rows
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Mukesh" <(E-Mail Removed)> wrote in message
> news2D37F96-E924-42BA-B8B4-(E-Mail Removed)...
> > Lets say I want color banding for cells
> >
> > column A to F
> > Row 27 to 226
> >
> > what should be the formula....
> >
> > Please advise.
> >
> > Thanks.
> > Mukesh
> >
>
>
>