I have a golf spreadsheet for scores if the score is under par the color is
red if it is par or over it is black. I have two scores columa's and a total
columa. When I do this the total columa will use the 1st score red or the
2nd score columa. So the total is not the right color. Please help. I use
a columa that I can change the par for each course. So my forumula has the
par in it everytime.

name score score total
player 71 72 143
red black red
player 73 71 144
black red black

This is how it should look, of course the numbers or in color not the color
written under the number.

Thank You