I have a table full of data (well, the results of formulae), where each row
has nice points of comparison (either Y or N; or strongly disagree, disagree,
neutral, agree or strongly agree).

What I had hoped to do was use Conditional Formatting to highlight those
values - within each row - that for each of the nine comparisons is
significantly higher than average (lets say 2 std devs? but Im not fussy).
For instance, if 100 people said yes and none said no, I'd want the 'yes' to
be highlighted... But if 60 people said yes and 40 people no, I don't care.

Is this possible without my having to set Conditional Formatting hundreds of
individual times, and if so, how?