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

Question

As you can see here i have the percents of made putts displayed next to the pro average and scratch golfers percents.&nbsp; I would like to turn the cells green or red based on if they are equal or greater to the scratch golfers.

hansvogelaar · Answer

FischerBuechele&nbsp;
Which cells exactly do you want to color?

fischerbuechele · Answer

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

hansvogelaar · Answer

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

fischerbuechele · Answer

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

hansvogelaar · Answer

FischerBuechele You haven't really answered my question, so I cannot help you.

Forum Discussion

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

Resources