| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to determine whether cell contains a formula? | Excel Worksheet Functions | |||
| how do I determine if a cell is used in a formula | Excel Discussion (Misc queries) | |||
| How can I determine if a cell has a value (#) or a formula (X*Y)? | Excel Discussion (Misc queries) | |||
| Can the =CELL formula be used to determine the worksheet tab name. | Excel Worksheet Functions | |||
| formula to determine if cell is merged? | Excel Worksheet Functions | |||
Linear Mode
