Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
Formula: =B3-C3. Format Custom as ;;; (this is so the value willnot show)
Conditional FormattingIcon sets, choose the 3 colored arrows Conditional FormattingManage RulesEdit rule, fill in the values (=0, between 0 and 0, <0) and make sure Type is Number (not percent) -- Kind regards, Niek Otten Microsoft MVP - Excel "DOUG" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
Niek: That worked great - thanks!. However, the icon will not center in the
cell. Have you any hints about that? DOUG "Niek Otten" wrote: Formula: =B3-C3. Format Custom as ;;; (this is so the value willnot show) Conditional FormattingIcon sets, choose the 3 colored arrows Conditional FormattingManage RulesEdit rule, fill in the values (=0, between 0 and 0, <0) and make sure Type is Number (not percent) -- Kind regards, Niek Otten Microsoft MVP - Excel "DOUG" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
Excel 2007
Here is an example done exactly like Niek suggested: http://www.mediafire.com/file/nttmolmo3m0/08_10_09.xlsx |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
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 "Herbert Seidenberg" wrote: Excel 2007 Here is an example done exactly like Niek suggested: http://www.mediafire.com/file/nttmolmo3m0/08_10_09.xlsx |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
In Conditional FormatIcon setsMore rules, check Show icon only
-- Kind regards, Niek Otten Microsoft MVP - Excel "DOUG" wrote in message ... 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 "Herbert Seidenberg" wrote: Excel 2007 Here is an example done exactly like Niek suggested: http://www.mediafire.com/file/nttmolmo3m0/08_10_09.xlsx |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
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 "Niek Otten" wrote: In Conditional FormatIcon setsMore rules, check Show icon only -- Kind regards, Niek Otten Microsoft MVP - Excel "DOUG" wrote in message ... 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 "Herbert Seidenberg" wrote: Excel 2007 Here is an example done exactly like Niek suggested: http://www.mediafire.com/file/nttmolmo3m0/08_10_09.xlsx |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
ICON Arrows UP or DOWN
and align center, of course
-- Kind regards, Niek Otten Microsoft MVP - Excel "DOUG" wrote in message ... 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 "Herbert Seidenberg" wrote: Excel 2007 Here is an example done exactly like Niek suggested: http://www.mediafire.com/file/nttmolmo3m0/08_10_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting (Icon sets - 3 Arrows) | Excel Worksheet Functions | |||
Conditional Formatting - Icon Rule - Three Color Arrows | Excel Discussion (Misc queries) | |||
Up & Down Arrows | Setting up and Configuration of Excel | |||
Up/down arrows | Excel Discussion (Misc queries) | |||
Up Arrows / Down Arrows | Excel Worksheet Functions |