To keep the internal datasheet simple, the conditional formatting dialog is not available in the internal datasheet. To use conditional formatting in think-cell, simply compile your data in a separate Excel workbook and link it via think-cell Excel data links (see the chapter Excel data links in our user manual).
If you do not need to change the conditions or colors anymore, you do not have to keep the Excel link after setting up everything. The data and conditions will be available in the internal think-cell datasheet after breaking the link (or deleting the Excel file). However, the conditional formatting cannot be changed after breaking the Excel link.
To use the conditional formatting for your think-cell chart, choose the Use Excel Fill on Top option as described in the section Color scheme of our user manual.
think-cell supports up to three rule types for conditional formatting. The conditional rule for the Cell Value may use one of the following options:
For the definition of the value range the following operators may be used:
Changing the number format by conditional formatting is not supported by think-cell.
Due to some restrictions in Microsoft Excel, the update of the think-cell chart might not occur immediately after changing the rules for conditional formatting. You can trigger an update by changing any data value of the respective chart. Two known cases are documented in the knowledge base articles