| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional number format in Excel 2007
I have an array of data where I don't want errors to display. I tried using
a conditional format where I would set the number format to ";;;" (non-displayed) if ISERROR(cell ref) is TRUE. The errors still displayed. Can anyone help me with this? (I cannot simply change the font color to equal the background color, because the background color itself depends on another conditional format.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Vs 2003 Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Format - Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Conditional Format with Formula | Excel Discussion (Misc queries) | |||
| Excel 2007 Conditional Format: Marking Absences | Excel Discussion (Misc queries) | |||
| Conditional format oddity in Excel 2007 | Excel Worksheet Functions | |||
Threaded Mode
