Conditional Formatting - Display a dash

A

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?
 
A

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?
 
A

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.
 
G

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
 

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