Conditional Formating
 

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.

Conditional Formating
 

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.
--
David Biddulph

"carl" wrote in message
...
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.