It can be done with the Select by Value option. Select your range and tick off Numbers. Choose Select cells that are greater, type 100 in the corresponding box, and click Select. All the cells that contain numbers that are greater than 100 will be highlighted.