Conditional Format for an object

[Nikki]

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%

 

[David Biddulph]

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(B2>94.999%,B2<99.999%)], and possibly a 3rd condition =B2>100%

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%