Hi,

Am Tue, 5 Aug 2014 16:13:12 +0000 (UTC) schrieb tb:

Is there a quick way to jump from one highlighted "#N/A" cell to the
next one? Otherwise I have to go though the whole big spreadsheet many
times in order to find all the cells that are highlighted...

try it with Enter
But if you change a cell the highlighting is gone

You can also use a macro to highlight the cells
Sub Makro1()
ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormu las, 16).Select
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional