Color Banding / Conditional Formatting
 

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

Color Banding / Conditional Formatting
 

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" wrote in message
...
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

Color Banding / Conditional Formatting
 

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

Color Banding / Conditional Formatting
 

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" wrote in message
...
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