How to Highlight
If you want to highlight a row that contains an NA error in Google Sheets, use the ISNA function.
The formula to highlight a specific cell with an NA error in Google Sheets is:
=ISNA(A1)
Enter that into the custom formula area in your conditional formatting window, and you'll automatically highlight any individual cell with the error.
Here's a related guide for any type of error: https://spreadsheetpoint.com/formulas...
To highlight an entire row, just choose where you want to search and use the following formula:
=ISNA($B1)
In this example, I'm searching column B and highlighting any row where I see an #N/A error.
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/
#GoogleSheets #GoogleSheetsTips #Spreadsheet