ICON Arrows UP or DOWN

[DOUG]

In MS Excel 2007, how would I set a conditional format to display an arrow,
"IF cell B3 >= Cell C3, GREEN ARROW UP" - (and if NOT, then RED ARROW DOWN)?

DOUG ECKERT

 

[Niek Otten]

Formula: =B3-C3. Format Custom as ;;; (this is so the value willnot show)
Conditional Formatting>Icon sets, choose the 3 colored arrows
Conditional Formatting>Manage Rules>Edit rule, fill in the values (>=0,
between 0 and 0, <0) and make sure Type is Number (not percent)

 

[Herbert Seidenberg]

Excel 2007
Here is an example done exactly
like Niek suggested:
http://www.mediafire.com/file/nttmolmo3m0/08_10_09.xlsx

 

[DOUG]

Niek: That worked great - thanks!. However, the icon will not center in the
cell. Have you any hints about that?

DOUG

 

[DOUG]

Herb: Thanks. However, the USAF network censors severed my connection to
your link instantly with the standard warning that internet use is logged and
monitored(!).

Niek's instructions worked well, but the icon would not center in the cell.
It is pasted way over on the left-hand side of the cell. I have asked him
about it.

Sincerely,
DOUG

 

[Niek Otten]

In Conditional Format>Icon sets>More rules, check Show icon only

 

[Niek Otten]

and align center, of course

 

[DOUG]

Niek: Please disregard that last. The cell formatting did work, although
the centering tool at the top of the screen did not. I am good to go, thanks
to you.

Sincerely,
DOUG ECKERT