Conditional Formatting - Display a dash

[AuditIA]

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?

 

[Andy_N1708 via OfficeKB.com]

Try this

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

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?

 

[Alan]

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.

 

[Alan]

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

Typo,
Sorry.

 

[Gord Dibben]

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