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.