Conditional formatting to highlight formulas. vs numbers

First add a VBA module to your workbook.  In it, add the VBA function

Function IsFormula(MyCell As Range) 
    IsFormula = MyCell.HasFormula 
End Function

Then go to the cell (for instance, A5) and from the main menu select

    Format, Conditional Formatting

• Under Condition 1 change the drop-down box from “Cell Value is” to “Formula Is”
• In the formula box type

            =IsFormula(A5)=FALSE   to highlight a number or

            =IsFormula(A5)=TRUE    to highlight a formula

Then you have to copy the formatting to all the other cells. You can‘t format

a block of cells all at once because they will only look at the top left cell in the block.