| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
