Identify cell that don t contain formula

Question

version: Excel 2010

Is there a way to quickly identify or create a simple macro to identify cells that don't have a formula?

--------------------------------
|=A1*1 |   151 | =A3*1 | =A4*1 |
--------------------------------
|=B1*1 | =B2*1 |   100 | =B4*1 | 
--------------------------------

Quickly highlight or change the font color of cells 151 and 100.

Answer 1

Select the range you wish to test, press Ctrl+G, and then click Special to complete the task quickly and easily without using VBA.

When you specify the cell type you desire and click OK, only those cell types will continue to be selected. To pick all cells in your situation that don't have formulae, choose Constants.