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.