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.
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.