Hey everyone, thanks for your help with this question. I am working on a report for work and I am trying to give a simple visual to show how close a facility is to meeting their goal and thought I could use conditional formatting instead of adding an additional column to an already large data set.
In one column I have the facility's current number and in the next column that facility's goal. The problem I'm running into is that I have over 100 facilities and they all have different goals so I'm not able to set the max value for the gradient fill to a specific value and instead need to base it off the value in the corresponding goal field. Is there a way to get the gradient fill to represent the progress to towards the corresponding goal? See example below
<tbody>
</tbody>
Is thee a way to get the current column (A) to have a gradient fill based on the goal column (B).
Thanks for your help!
Isaac
In one column I have the facility's current number and in the next column that facility's goal. The problem I'm running into is that I have over 100 facilities and they all have different goals so I'm not able to set the max value for the gradient fill to a specific value and instead need to base it off the value in the corresponding goal field. Is there a way to get the gradient fill to represent the progress to towards the corresponding goal? See example below
Current | Goal |
693 | 1500 |
677 | 900 |
214 | 300 |
78 | 900 |
<tbody>
</tbody>
Is thee a way to get the current column (A) to have a gradient fill based on the goal column (B).
Thanks for your help!
Isaac