I have a huge Excel sheet where I regularly import mass data into. This data is input to calculations per row. Sometimes, the imported data results in a #NV error in the calculated data.
I would like to be informed when that happens. So I thought, I would use conditional formatting on one single cell if Excel finds #NV in a range which is input for formatting evaluation formula.
Do you know a way to detect #NV in a range via a formula? Seems that isnv() triggers only if all cells in a range are #NV.
I am on Excel 2003.
Edit: adapted title to English