Conditional formatting

[Glenno557]

Using Excel 2013, I have used index/match query, where the result in some cells returns as #N/A due to the source not containing a number that I've specified. I'd like to conditionally format the "#N/A" result to show as "0", but have been unable to turn up a solution, short of downloading software to do it. Any help would be much appreciated? Cheers

 

[sandy666]

try =IFNA(your_formula,0)
without conditional formatting

 

[Glenno557]

Excellent! That worked perfectly - thanks a lot, good stuff!

 

[sandy666]

you are welcome & thanks for the feedback

for future

Excel functions (alphabetical) - Microsoft Support

A complete list of all Excel functions in alphabetical order.

support.microsoft.com

for older version than XL2010 you can use IFERROR()