Conditional Formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl - 12 Sep 2007 16:18 GMT

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.

Reply to this Message

David Biddulph - 12 Sep 2007 17:03 GMT

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.

Signature

David Biddulph

> My data looks like this:
>
[quoted text clipped - 10 lines]
>
> Thank you in advance.

Reply to this Message