How can I highlight cells whose content is not parsable as number?
Google-sheets – Highlight cells whose content cannot be parsed as number
conditional formattinggoogle sheets
Related Solutions
You can use a range as a parameter for the ISFORMULA() function.
e.g. If you want to highlight all cells containing formulas in the range A1:J10, then you can use the formula =ISFORMULA(A1:J10) and apply it to the range A1:J10.
Note that this works with normal ranges (e.g. B2:F30), but not with infinite ranges (e.g. B:F).
The answer to the question you linked contains the answer to this one. But since it apparently didn't get through, here it is again:
In conditional formatting, you enter the formula as it should apply to the upper left corner of the formatted range. The spreadsheet will apply it to the rest of the range using relative references. So, if the upper left corner of formatted range is C4, then
=B4means "the value in the cell to the left of this one".=$B4means "the value of the cell in B column of this row"=C$1means "the value at the top of this column"=$B$2means "the value in cell B2"
Related Topic
- Google-sheets – How to highlight duplicate cells
- Google-sheets – Highlight second highest number in Google Sheets row
- Google Sheets Conditional Formatting – Alternate Row Color by Unique Sorted Values
- Google-sheets – How to you find or highlight all cells having validation in Google Sheets
- Google Sheets – Highlight Cell Red if Less Than 6 Digits Without Affecting Blank Cells
- Google Sheets – How to Highlight Cell if Any of 6 Cells to the Right Are Not Blank
- Google Sheets – Conditional Formatting Based on Data in Two Columns
Best Answer
Use conditional formatting with a custom formula. For example, select cell A1, go to Format/Conditional formatting, select "custom formula" and enter
In the same dialog you can choose the range to which this formatting should be applied.