Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top