You can do this by using a colouring expression:
Colour by (Cell Values)
Check the box 'Colour the grouping using another expression'
Add an expression, I got mine to work with this:
case when (
First([Measure])="Measure 1") and (First([Facility])="Facility A") and (First([Value])>40) then "Green" when (
First([Measure])="Measure 1") and (First([Facility])="Facility B") and (First([Value])>50) then "Green" when (
First([Measure])="Measure 1") and (First([Facility])="Facility C") and (First([Value])>60) then "Green"
else
"Red"
end
Select your desired colours below and voila: