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.
|