My data looks like this:

A B C D
0.00% 0.00% 100.00% 0.00%
5.92% 7.06% 13.98% 32.51%
4.05% 11.19% 17.65% 54.46%


Is there a way to entire row if any value in the row is greater than 50%
and/or Bold the Font of ColB if the cell value is less than 2%.

So in data above, rows 1 and 3 would be highlighted and B1 would be Bold Font.

Thank you in advance.