Conditional Formatting

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

Guest

I have a table like this:


A B C D E F
1 12.73% 32.16% 24.86% 10.08% 6.53% 13.64%
2 5.37% 30.39% 40.66% 13.36% 3.86% 6.35%
3 3.02% 24.38% 60.41% 3.89% 2.24% 6.06%
4 5.23% 33.46% 22.54% 20.42% 9.55% 8.79%


I am trying to use the conditional formatting feature to highlight a cell on
a given row, if the value is less than the value in column A.

So in the first row, the values in Col D and E would be highlighted.

Thank you in advance.
 
Try the following...

1) Select/highlight B1

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=(B1<>"")*(B1<$A1)

4) Choose your formatting

5) Click Ok and copy the format to other cells.

Hope this helps!
 
Back
Top