10
X X X
190
This basically represents a 10th frame in Bowling.The formula to get the
bowling score is in the cell where the 190 is represented here. When I center
the score in the 3 cells and conditional color it the other 2 cells will not
show the same color as the scoring cell. I want all 3 cells to show green
over 200 yellow for 150-199 and red for anything below 150.When i put
conditional format the scoring cell turns yellow as i want but the other
cells turn red. Hope this makes sense. Thanks Karl