Bob

Sorry for all the trouble. But when I put a score in the first round above
par which is 72, it shows up red in the total column, it needs to show up in
black. Red is under par and black is par or above. When I use the 2x it
works at the two rounds are complete. I'm just trying to get the total to
look right after the first round.

thank you

"Bob Phillips" wrote:

I think you need to explain how that shows up as black, as a score of 81
would push the 2 round score well above par.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tommy" wrote in message
...
When I use that if the score is 81 in the first round the total shows up
in
red i need it to show up in black.

"Bob Phillips" wrote:

Wouldn't you check total against 2 times par?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tommy" wrote in message
...
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