Shading a range based on a single cell value.

D

Drew

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.
 
R

RagDyer

Use Conditional Formatting.

Select A1:A15, then:

<Format> <ConditionalFormat>

Click "Formula Is"
And enter this formula:
=$A$1>0

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!
==============================================
 
D

Drew

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?
 
R

RagDyer

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.CFPlus.Download.html


--
HTH,

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