Hi,

Is it possible to do some formula for color scale conditional formatting with exception? (or some another solution)
Untitled-1.jpg Well as you can see, I would like to leave conditional formatting for lines, where quantity is equal to 1. This is simple example. In reality, i would like to skiped some hard and painful work with doing exceptions manually in much more complicated data sets.

Thx!