Conditional Format for an object

  • Thread starter Thread starter Nikki
  • Start date Start date
N

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%
 
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%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting 3
Conditional Formatting by percent range 2
Condtional Formatting, Cell Upon Cell 3
3 COLOR SCALE CONDITIONAL FORMATING WITH FORMULAS 3
IF formula with conditional formating help please 3
Conditional Format for Object 19
Excel 2003 - Adding up cells that contain Conditional Formatting 10
COUNT IF - Conditional Formatting 2

Back
Top