8 Replies Latest reply on Sep 16, 2015 8:43 AM by Lance Dacey

    Conditionally Formatting Tables

    Lance Dacey

      I have a table with monthly performance. There are 9 metrics and each have a different target which are all captured in an individual parameter per metric. I need to make each cell on the column be either red or green depending on if it is meeting the target or not. When I tried this, it was making the entire row a certain color which is not the behavior I am looking for.

       

      Can someone point out a guide?

       

       

        

      Target5%30%2%<15<12%>97%<25>75%>70%
      MonthMetric 1Metric 2Metric 3Metric 4Metric 5Metric 6Metric 7Metric 8Metric 9
      17.75%26.93%5.63%11.8511.68% 22.3577.68%67.93%
      26.59%27.88%5.98%12.0610.59%96.11%22.2979.90%70.54%
      37.33%27.56%4.46%11.9110.72%96.39%21.7184.65%70.50%
      47.26%27.76%3.89%10.9610.19%96.10%20.8686.74%68.29%
      57.29%29.80%3.76%10.6411.52%96.43%19.0680.94%64.03%
      66.23%29.28%3.52%10.3610.18%96.71%19.0584.87%68.37%
      75.67%28.79%3.50%8.4810.56%97.00%18.585.19%65.00%
      85.99%30.20%4.07%8.7712.22%96.81%18.8884.32%66.51%
      95.32%28.64%3.01%9.212.47%97.29%18.2685.63%71.24%
      105.83%28.48%3.24%9.3612.01%97.27%17.2685.39%68.23%
      114.83%30.04%4.22%9.5411.52%97.08%19.4487.57%63.56%
      125.77%28.42%3.73%11.2212.68%96.64%19.4184.28%66.87%
      136.00%29.22%4.76%1013.00%97.19%18.8684.33%66.53%
      145.50%30.18%4.16%1012.33%97.15%18.4385.99%65.70%
      154.93%28.32%3.16%10.1711.74%97.02%18.1285.65%65.27%
      165.97%29.93%2.75%10.0211.41%94.63%17.6785.98%63.86%
      176.27%28.52%4.31%10.0412.48%94.31%17.286.62%63.33%
      185.86%27.47%6.05%10.3311.55%94.77%17.9586.93%69.56%
      196.05%28.26%4.77%10.5211.83%94.45%18.187.96%69.51%
      205.73%27.98%7.17%10.6812.02%95.05%18.2987.63%73.26%
      210.85%27.65%4.79%10.5812.87%95.06%18.64 73.95%