The American Optometric Association suggests that children should have their first regular eye exam at six months of age. Another vision exam should take place when a child is around two or three years of age when their vision undergoes its most rapid development and vision correction is most effective.
The ISNUMBER function is a quick, easy way to check if a cell contains a number. Our example used the IF function to illustrate how ISNUMBER can be used. If you haven't used IF in a formula before, you can read our lesson on the IF function here.
However, if you want more flexibility, you can use your own formula, as explained in this article. If you want to highlight cells that contain certain text, you can use a simple formula that returns TRUE when a cell contains the text (substring) that you specify. For example, if you want to highlight any cells in the range B2:B11 that contain the text dog, you can use: =ISNUMBER(SEARCH(dog,B2)) Note: with conditional formatting, it's important that the formula be entered relative to the active cell in the selection, which is assumed to be B2 in this case.