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.