Part A - as far as I know you cannot assign conditional formatting to an
object such as a circle, text box or square.

For part B
I'd start by going ahead and setting the cell shading of B2:B4 as yellow, it
will save you one conditional test. Then select B2:B4 and use conditional
formatting and choose the Formula Is option and enter a statement like this
as the first condition:
=A$1<10
and set the shading condition, then Add another condition, again using
Formula Is and a condition like this:
=A$150
and set up your conditional shading. Change the values of 10 and 50 as
appropriate for the range in question.

"Pivot Man" wrote:

Looking to change the format of an object...change the color of a circle to
red if less than, yellow if between two values and green if greater than a
value. I can use condiitional formatting in a cell, just wondering if

A) you can apply condiitonal formatting to an object
or B) can you apply conditional formatting to cells outside of the result
cell. ie, depending on the results in cell A1, I want to change the color in
Cells B2 to B4.

Thanks