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

Copper Contributor

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

@FischerBuechele 

Which cells exactly do you want to color?

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

@FischerBuechele 

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

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

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

what are you confused by its pretty well stated in the initial post

@FischerBuechele 

I have no idea how to solve this with the information I have. I must be stupid...