Multiple Conditional analysis & formatting

This tool is suitable to give format to cells in a database, based on previously established criteria defined in a decision table.

To use this tool, you will need data entered in a range of cells as database, and a decision table. This tool may be very useful to monitor stock prices based in the cell colors you should have specified in the decision table.

You should first define a model, and then execute it. But you can also save it and save settings that define how often it will be run, in addition to the automatic update of Stock Quotes in the Refresh Settings button.

We are going to see some examples of how to use this tool.

First, design a data layout as seen in the following screen shot. The function SQ( ) has been entered in column B, which retrieves data from MSN Money. You can enter this function manually just as any other Excel function.