Hey everyone!
I would like to use conditional formatting (the color scale option) to highligh a column of data based on another columns data.
Here is how my data is set up
<tbody>
Actual
Target
Person 1
64.3%
50.0%
Person 2
67.6%
50.0%
Person 3
63.1%
50.0%
Person 4
59.4%
50.0%...