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%

If you want to use the content of one cell to govern the format of another
in CF, use "Formula is", not "Cell value is", and set the first condition as
=B2<94.999%, add a second condition =B2<99.999% [or possibly
=AND(B294.999%,B2<99.999%)], and possibly a 3rd condition =B2100%

Do you reall want the cell unformatted if it is equal to 94.999%, and if
between 99.999% and 100% (both inclusive)?
If not, be careful of your distinction between and =, between < and <=,
and between 99.999% and 100%
--
David Biddulph

"Nikki" wrote in message
...
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%