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
|