CelesteCS Conditions plugin allows one to apply table cell formatting and text replacement based on specified conditional rules. It contains the following macros:
- Conditional Rule macro, which checks the conditions for applying formatting options to conformant elements
- Conditional Rules Manager macro, which applies conditional formatting rules to own contents
Both these macros work in conjunction: Conditional Rules Manager macro should contain at least one Conditional Rule macro and from the other side Conditional Rule macro cannot be specified separately from the Conditional Rules Manager as it is just a container for conditional rules parameters.
In addition to the Conditional Rule macro, the following visual formatting macros are also available (each also used inside Conditional Rules Manager macro):
- Conditional 2-Color Scale macro, which applies a color gradient to a range of cells, from a minimum to a maximum color
- Conditional 3-Color Scale macro – New! Datacenter Only – the same, with an additional midpoint color
- Conditional Data Bar macro – New! Datacenter Only – draws an in-cell bar proportional to the cell’s value
- Conditional Icon Set macro – New! Datacenter Only – places one of three icons next to a cell’s value, based on two thresholds
Find out more here: