ICON Arrows UP or DOWN

D

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
 
N

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)
 
D

DOUG

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

DOUG
 
D

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top