Conditional Formating

[Guest]

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.

 

[David Biddulph]

Because once it satisfies one condition it doesn't test later ones, you may
need to do it in stages.

For the whole range, set Formula is: =MAX($A1:$D1)>50% to highlight the
rows.

Then for column B change it to 3 conditions:
First condition: Formula is: =AND(MAX($A1:$D1)>50%,B1<2%) to highlight and
bold
Second condition: Cell value is: less than: =2% to bold
Third condition: as for whole range above.