I need the bar colors to change after reaching ONE particular point.

how do i do that? I have searched the many different posts or threads, they
all seem to be relative to more than one point or sectioned off by tiers of
breaking points.

Even the simple condition format from the peltier is based on two points. I
need a forumla that looks like (if $b$3=$c$3,...then the color=red).