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.

Furthermore, a pivot table has been created in other sheet with the previously defined criteria.

Note: You can create any number of models following the above steps, but only one can be active for automatic execution.