Forum Discussion
How to make an individual cell change red or green based on value in the cell
As you can see here i have the percents of made putts displayed next to the pro average and scratch golfers percents. I would like to turn the cells green or red based on if they are equal or greater to the scratch golfers.
Which cells exactly do you want to color?
- the cells that show the percents for each distance. B;2-B;10
How do we match the distances in A2:A10 (1, 1.5, ..., 6) those in D4:D7 (2, 3, 4, 5)?
.png){kind=link}