# How to make an individual cell change red or green based on value in the cell

Copper Contributor

# 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.

7 Replies

# Re: How to make an individual cell change red or green based on value in the cell

Which cells exactly do you want to color?

# Re: How to make an individual cell change red or green based on value in the cell

the cells that show the percents for each distance. B;2-B;10

# Re: How to make an individual cell change red or green based on value in the cell

How do we match the distances in A2:A10 (1, 1.5, ..., 6) those in D4:D7 (2, 3, 4, 5)?

# Re: How to make an individual cell change red or green based on value in the cell

couldnt we just do a conditional format for greater or lessthan or equal too and color it by that?