View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

Here's something that might be acceptable:

Insert a column to the right of the % of Goal column

Select a cell to the right of a Goal% value.

InsertSymbol...then select a solid circle and insert it in the cell.
(Note: you'll need to change the font for that cell to match the font used
in the symbol selection window)

Then, set up a conditional format that depends on the value in the Goal%
cell to set the font color for the circle:Green for excellent performance,
Yellow for marginal peformance, and Red for bad performance.

Example: for a percent in Cell A1, the conditional format for Cell B1 would
be:

formatConditional Formatting
Condition1:
Formula Is: =(A1=0.05)
Font Color: Green

Condition2:
Formula Is: =and(A1=0,A1<0.05)
Font Color: Yellow

Condition2:
Formula Is: =(A1<0)
Font Color: Red

Is that something you can use?

Ron