Conditional Formatting
It applies to the cell value the conditional format is applied to... It also
expects the cell to be formatted as a percentage...
If cell 4 has a value which is greater than 67% then it will show UP icon...
"gjuarez" wrote:
Using Conditional formating Icons (Arrows)
Cell 1 has a YTD formula, Cell 2 through 4 has Numerical Data
Using the default formula of:
Up Arrow = 67%
Side Arrow <67% and = 33%
Down Arrow < 33%
What value is the per cent being applied to?
I have an instance where Cell 4 is greated than Cell 3 but displays a side
arrow.
--
GMJ
|