Conditional formatting applied to all cells in a column based on Grand Total value compared to cell value
Is it is possible to apply conditional formatting to a cell using a condition similar to this:
“formula”: “if(#value > #grandtotal-10, ‘trueStyle’)”
Thank you for your question. The conditional formatting works for each data cell separately. It allows making comparations with numbers but there are no options which allow referring to the grand total cells.
Please let us know if you have any additional questions here.
Okay, thats disappointing.
Is there any plans to introduce this functionality?
This feature is not included in our development plans for the next releases at the moment. However, we will notify you if something changes.