Navigation: FXLV4_Manager > Formula Explorer Pro Overview > Working with Explorer Pro >

Exploring Formulas from Cells, Defined Names, Conditional Formats and Data Validations

 

 

 

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.

 

 

 

Copyright © 2020 Decision Models Ltd