Exploring Formulas from Cells, Defined Names, Conditional Formats and Data Validations
Exploring Cell Formulas
Click Control-M or press the Explorer Pro button to launch Explorer Pro for the formula in the active cell (Home)
Exploring Named Formulas
From Name Manager Pro select the named formula you want to explore and click the Analyse button
The name of the Named Formula is shown at the top left, and the background of the Home address box is light blue. You can use all Explorer Pro features on Named Formulas except Edit mode.
Exploring Conditional Format Formulas
Select a cell using one or more conditional format formulas and click Ctrl-Alt-M (or Ctrl-Alt-F if Explorer Pro has the Focus). Explorer Pro will show a form for you to choose the conditional format formula.
Select one of the Conditional format formulas and click OK.
“Conditional Format” is shown at the top left, and the background of the Home address box is light green. You can use all Explorer Pro features on Conditional Formats except Edit mode.
Exploring Data Validation Formulas
Select a cell using a Data Validation formula and click Shift-Ctrl-Alt-M (or Shift-Ctrl-Alt-F if Explorer Pro has the focus).
“Data Validation” is shown at the top left, and the background of the Home address box is light orange. You can use all Explorer Pro features on Data Validation formulas except Edit mode.
|