How to determine if a cell contains a value or a formula?
 

I have data that goes from projections to actuals. I would like to identify
either through a formula or conditional formatting whether a contains a
formula or has been over written with a value.

How to determine if a cell contains a value or a formula?
 

Select all the cell you want to examine and press F5.

Click the SPECIAL command button in the lower-left hand corner of the dialog
box, and then click the FORMULAS option button and click OK. Only cell
w/formulas will be selected.

You could then format those selected cells with a shaded interior or
something...
--
Kevin Backmann


"George" wrote:

I have data that goes from projections to actuals. I would like to identify
either through a formula or conditional formatting whether a contains a
formula or has been over written with a value.