Menu
Download Free Trial

Conditional formatting applied to all cells in a column based on Grand Total value compared to cell value

Hi,
Is it is possible to apply conditional formatting to a cell using a condition similar to this: 
“formula”: “if(#value > #grandtotal-10, ‘trueStyle’)”
Thanks
Ben
 
 

3 answers

Public
Dmytro Zvazhii Flexmonster April 10, 2017

Hello Ben,
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.
Best regards,
Dmytro.

Public
Ben Shenton April 10, 2017

Hi,
Okay, thats disappointing.
Is there any plans to introduce this functionality?
Thanks again
Ben

Public
Dmytro Zvazhii Flexmonster April 10, 2017

Hello Ben,
This feature is not included in our development plans for the next releases at the moment. However, we will notify you if something changes.
Regards,
Dmytro.

Please login or Register to Submit Answer