All:
I would like to get help with formatting an object (circle for a stoplight
report that compares sales). For example, I have 100% in one column and the
object in the cell column to the left. I need to set the conditional format
to look at the 100% and automatically change the object in the cell to the
left with a green, red, or yellow color.

=yellow 97%
=yellow 96%
=green 100%
=red 51%

Criteria is based on if the %'s above are <94.999%, between 94.999%
<99.999%, 100%