@RISK Tip: Format Cells with @RISK Inputs and Outputs

You can easily flag any cell that contains @RISK input distribution functions or @RISK output functions using the Application Settings window of @RISK. Application Settings is located under the Utilities menu in the @RISK ribbon:

Format Cells with @RISK Inputs and Outputs
 
Here you can apply default cell formats to cells in your workbook where @RISK inputs and outputs are located. You can select a color for cell font, border or background.

Here you can apply default cell formats to cells in your workbook where @RISK inputs and outputs are located.
 
Using the Application Settings Dialog, a wide variety of @RISK settings can be set at default values that will be used each time the program runs. These include graph color, displayed statistics, coloring of @RISK cells in Excel, and others.

@RISK is an add-in to Microsoft Excel. @RISK performs risk analysis using Monte Carlo simulation to show you many possible outcomes in your Microsoft Excel spreadsheet—and tells you how likely they are to occur. This means you can judge which risks to take and which ones to avoid, allowing for the best decision making under uncertainty.

» Read more about Application Settings in @RISK

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s