Allow no conditional formatting (or transparent) to be applied if the condition is not met

Description of the enhancement required:

Enhance conditional formatting so that it will be possible to set the fill if the condition is met but if not, the Grid Style is respected.

Currently the conditional formatting is working with a range of values where is set the fill in the left range and in the right range (with fading colors between the ranges). I want to be able to set a condition IF <Line Item> = 123abc and that the impact is that it meets the condition the fill is adjusted by a color and else it just takes the Grid Style we've defined.


5 votes

In Review · Last Updated


  • Status changed to: In Review
  • Yes, this would be a valuable addition and make conditional formating more stronger for some customer use cases. We discussed this in L2 training today; especially the use of Transparency and colours.



Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!