Conditional Formatting - Display a dash

I must be doing something wrong - I can't get it to work. I typed in exactly
what it said in the HELP example, but it still doesn't work. I entered
=IFERROR(A2/A3,"-") It put a green triangle in the upper left corner, but
did not change the view of that cell to a "-". What am I supposed to do?

Try this

= if(iserror(A2/A3),'"-")

AuditIA wrote:
I must be doing something wrong - I can't get it to work. I typed in exactly
what it said in the HELP example, but it still doesn't work. I entered
=IFERROR(A2/A3,"-") It put a green triangle in the upper left corner, but
did not change the view of that cell to a "-". What am I supposed to do?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

You wouldn't use conditional formatting to do that, it only changes the
formatting like colours, fonts etc. '-' isn't a format, it's a character.
Just your the formula in the cell you want to display it,
Regards
Alan.
"AuditIA" wrote in message
...
I must be doing something wrong - I can't get it to work. I typed in
exactly
what it said in the HELP example, but it still doesn't work. I entered
=IFERROR(A2/A3,"-") It put a green triangle in the upper left corner, but
did not change the view of that cell to a "-". What am I supposed to do?

Just PUT your the formula in the cell you want to display it

Typo,
Sorry.
"Alan" wrote in message
...
You wouldn't use conditional formatting to do that, it only changes the
formatting like colours, fonts etc. '-' isn't a format, it's a character.
Just your the formula in the cell you want to display it,
Regards
Alan.
"AuditIA" wrote in message
...
I must be doing something wrong - I can't get it to work. I typed in
exactly
what it said in the HELP example, but it still doesn't work. I entered
=IFERROR(A2/A3,"-") It put a green triangle in the upper left corner,
but
did not change the view of that cell to a "-". What am I supposed to do?

Works for me in Excel 2007 when that formula is entered in a cell other than
A2 or A3 and an error occurs.

What's in A2 and A3?

BTW...........this is not Conditional Formatting.


Gord Dibben MS Excel MVP


On Fri, 15 May 2009 12:37:01 -0700, AuditIA
wrote:

I must be doing something wrong - I can't get it to work. I typed in exactly
what it said in the HELP example, but it still doesn't work. I entered
=IFERROR(A2/A3,"-") It put a green triangle in the upper left corner, but
did not change the view of that cell to a "-". What am I supposed to do?