View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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.