excel_003.jpg

Simple: I just want the value in B1 to be green anytime it's greater than or equal to 50.0%, and red if it's less than 50.0%. I've applied the conditional formatting as shown, but it's just showing red no matter what, even if I manually change it to a value higher than 50.

Can someone help?