Conditional Formatting - Display a dash

  • Thread starter Thread starter AuditIA
  • Start date Start date
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?
 
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.
 
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.
 
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
 
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

Similar Threads

Non matching text data of the same values 3
What is small green triangle in upper left corner of cell? 6
Subtotals 5
Formatting zeros as dashes 4
Conditional formatting in Excel 2010 2
Conditional Formatting Issue 3
How do I ignore the "Number stored as text" error message permane. 3
dashes around cells 3

Back
Top