Conditional Formatting

[gjuarez]

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.

 

[Sheeloo]

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