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.
I would like to lock a range of cells based on the contents of a single cell. In Cell G2 the user is expected to select a number or an X from a drop down list. If they select the X I would like to lock the range of cells between G3:G66 and if possible add some conditional formatting that would change the background color of the cell.