Dear all,

If let say I have a number 100 at E9 and number 50 at J9
If I want to do conditional formatting based on number > 75 to be in green and <75 in red,

I wish to have the adjacent cell coloured as well...up low left right
let say from D7 to G12 in green and I7 to L12 in red.
Is that possible?

Thank you