conditional formatting range with colour scale

[jstk886]

Hi all,

I’ve got a conditional formatting problem which I can’t get my head around.

I want to be able to format blocks of cells with the same colour (eg C2:C4, D2:D4, E2:E4 etc) based on whether a condition is met in one of those cells, in my case if the discount is within a certain range.

Is this possible? Have attached an example
Thanks