How would I shade a certain range based on the value of a cell within that
range.

For example: When the value of A1 0, It would shade range (A1:A15) a
specific color from the color pallet.

On the Toolbar, try Format Conditional Formatting
You will need to use the 'Formula Is' option, Look in Help or go onto
http://contextures.com/xlCondFormat02.html
where you will find an excellent tutorial from Debra Dalgleish,
Regards,
Alan.
"Drew" wrote in message
...
How would I shade a certain range based on the value of a cell within that
range.

For example: When the value of A1 0, It would shade range (A1:A15) a
specific color from the color pallet.

Use Conditional Formatting.

Select A1:A15, then:

<Format <ConditionalFormat

Click "Formula Is"
And enter this formula:
=$A$10

Then, click on Format, and choose whatever you wish.

Then <OK <OK
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Drew" wrote in message
...
How would I shade a certain range based on the value of a cell within that
range.

For example: When the value of A1 0, It would shade range (A1:A15) a
specific color from the color pallet.

Conditionally format A1:A15 using the following formula: =$A$2<0
Here's how:
http://www.officearticles.com/excel/...ft_ excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Drew" wrote in message
...
How would I shade a certain range based on the value of a cell within that
range.

For example: When the value of A1 0, It would shade range (A1:A15) a
specific color from the color pallet.

Alright, thanks all. That was easier than I thought. Now I've encountered
another problem. I need to do 70 more times in the same worksheet. Is the
max 3?


"Anne Troy" wrote:

Conditionally format A1:A15 using the following formula: =$A$2<0
Here's how:
http://www.officearticles.com/excel/...ft_ excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Drew" wrote in message
...
How would I shade a certain range based on the value of a cell within that
range.

For example: When the value of A1 0, It would shade range (A1:A15) a
specific color from the color pallet.

If you're talking about coloring each row a different color, what's wrong
with making a 3 color repeating pattern.
You could easily see the difference between rows.

You could check out this link for an add-in, which will allow more colors:

http://www.xldynamic.com/source/xld.....Download.html


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Drew" wrote in message
...
Alright, thanks all. That was easier than I thought. Now I've
encountered
another problem. I need to do 70 more times in the same worksheet. Is
the
max 3?


"Anne Troy" wrote:

Conditionally format A1:A15 using the following formula: =$A$2<0
Here's how:

http://www.officearticles.com/excel/...ft_ excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Drew" wrote in message
...
How would I shade a certain range based on the value of a cell within
that
range.

For example: When the value of A1 0, It would shade range (A1:A15)
a
specific color from the color pallet.