Conditional Format for an object
 

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%

Conditional Format for an object
 

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%