Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Display a dash
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Display a dash
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Display a dash
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Display a dash
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use conditional formatting to scale a display value? | Excel Discussion (Misc queries) | |||
How to display dash instead of #REF | Excel Worksheet Functions | |||
How do I display all conditional formatting in Excel? | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) |