How can I tell if a cell has a formula in it?

[willphillipson]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Looking for some help with a problem relatively well solved on the PC side...

To identify - programmatically - whether a cell contains a formula, as opposed to text or a number, etc., one can use an XLM macro/function on the PC side: =GET.CELL(48,INDIRECT("rc",FALSE))

Any ideas on how to do that in Excel Mac:2008?

My goal is to highlight cells in a spreadsheet, using conditional formatting, that do NOT have formulae... This way I can identify the place holders that need to be edited.

Thanks!
Will.

 

[Mike Middleton]

Will -

"Non-programmatically" you might be able to use Edit | Go To | Special |
Formulas ...

Programmatically, you could use Insert | Sheet | Other | Excel 4.0 Macro
Sheet, and write XLM code using your GET.CELL function.

- Mike
http://www.MikeMiddleton.com



Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel

Looking for some help with a problem relatively well solved on the PC
side...

To identify - programmatically - whether a cell contains a formula, as
opposed to text or a number, etc., one can use an XLM macro/function on the
PC side: =GET.CELL(48,INDIRECT("rc",FALSE))

Any ideas on how to do that in Excel Mac:2008?

My goal is to highlight cells in a spreadsheet, using conditional
formatting, that do NOT have formulae... This way I can identify the place
holders that need to be edited.

Thanks!
Will.

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Looking for some help with a problem relatively well solved on the PC side...

To identify - programmatically - whether a cell contains a formula, as opposed
to text or a number, etc., one can use an XLM macro/function on the PC side:
=GET.CELL(48,INDIRECT("rc",FALSE))

Any ideas on how to do that in Excel Mac:2008?

My goal is to highlight cells in a spreadsheet, using conditional formatting,
that do NOT have formulae... This way I can identify the place holders that
need to be edited.

Thanks!
Will.

Where is this code? In the conditional format? You do not need the indirect
reference, as this will return what you want for the current cell. This
should also work fine in Excel 2008. What is not working?