Change cell colors with rule and reference value in another field

Trying to figure out how to reference another field for a shot when creating a formatting rule.

As example, if I want a field to change color if the value in it is greater than a value in another field for the same shot.

I figured it would be able to work by calling the field like this but it isn’t accepted.

Bid Cost - is greater than: {entity.Shot.sg_shot_cost}