Conditional Formatting
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.
|