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
Wouldn't you check total against 2 times par?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Tommyquot; gt; wrote in message
...
gt; I have a golf spreadsheet for scores if the score is under par the color
is
gt; red if it is par or over it is black. I have two scores columa's and a
total
gt; columa. When I do this the total columa will use the 1st score red or the
gt; 2nd score columa. So the total is not the right color. Please help. I
use
gt; a columa that I can change the par for each course. So my forumula has
the
gt; par in it everytime.
gt;
gt; name score score total
gt; player 71 72 143
gt; red black red
gt; player 73 71 144
gt; black red black
gt;
gt; This is how it should look, of course the numbers or in color not the
color
gt; written under the number.
gt;
gt; Thank You
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.
quot;Bob Phillipsquot; wrote:
gt; Wouldn't you check total against 2 times par?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Tommyquot; gt; wrote in message
gt; ...
gt; gt; I have a golf spreadsheet for scores if the score is under par the color
gt; is
gt; gt; red if it is par or over it is black. I have two scores columa's and a
gt; total
gt; gt; columa. When I do this the total columa will use the 1st score red or the
gt; gt; 2nd score columa. So the total is not the right color. Please help. I
gt; use
gt; gt; a columa that I can change the par for each course. So my forumula has
gt; the
gt; gt; par in it everytime.
gt; gt;
gt; gt; name score score total
gt; gt; player 71 72 143
gt; gt; red black red
gt; gt; player 73 71 144
gt; gt; black red black
gt; gt;
gt; gt; This is how it should look, of course the numbers or in color not the
gt; color
gt; gt; written under the number.
gt; gt;
gt; gt; Thank You
gt;
gt;
gt;
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)
quot;Tommyquot; gt; wrote in message
...
gt; When I use that if the score is 81 in the first round the total shows up
in
gt; red i need it to show up in black.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Wouldn't you check total against 2 times par?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I have a golf spreadsheet for scores if the score is under par the
color
gt; gt; is
gt; gt; gt; red if it is par or over it is black. I have two scores columa's and
a
gt; gt; total
gt; gt; gt; columa. When I do this the total columa will use the 1st score red or
the
gt; gt; gt; 2nd score columa. So the total is not the right color. Please help.
I
gt; gt; use
gt; gt; gt; a columa that I can change the par for each course. So my forumula
has
gt; gt; the
gt; gt; gt; par in it everytime.
gt; gt; gt;
gt; gt; gt; name score score total
gt; gt; gt; player 71 72 143
gt; gt; gt; red black red
gt; gt; gt; player 73 71 144
gt; gt; gt; black red black
gt; gt; gt;
gt; gt; gt; This is how it should look, of course the numbers or in color not the
gt; gt; color
gt; gt; gt; written under the number.
gt; gt; gt;
gt; gt; gt; Thank You
gt; gt;
gt; gt;
gt; gt;
Bob
soory it works, replied to wrong post.
thanks
quot;Bob Phillipsquot; wrote:
gt; I think you need to explain how that shows up as black, as a score of 81
gt; would push the 2 round score well above par.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Tommyquot; gt; wrote in message
gt; ...
gt; gt; When I use that if the score is 81 in the first round the total shows up
gt; in
gt; gt; red i need it to show up in black.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Wouldn't you check total against 2 times par?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I have a golf spreadsheet for scores if the score is under par the
gt; color
gt; gt; gt; is
gt; gt; gt; gt; red if it is par or over it is black. I have two scores columa's and
gt; a
gt; gt; gt; total
gt; gt; gt; gt; columa. When I do this the total columa will use the 1st score red or
gt; the
gt; gt; gt; gt; 2nd score columa. So the total is not the right color. Please help.
gt; I
gt; gt; gt; use
gt; gt; gt; gt; a columa that I can change the par for each course. So my forumula
gt; has
gt; gt; gt; the
gt; gt; gt; gt; par in it everytime.
gt; gt; gt; gt;
gt; gt; gt; gt; name score score total
gt; gt; gt; gt; player 71 72 143
gt; gt; gt; gt; red black red
gt; gt; gt; gt; player 73 71 144
gt; gt; gt; gt; black red black
gt; gt; gt; gt;
gt; gt; gt; gt; This is how it should look, of course the numbers or in color not the
gt; gt; gt; color
gt; gt; gt; gt; written under the number.
gt; gt; gt; gt;
gt; gt; gt; gt; Thank You
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;
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
quot;Bob Phillipsquot; wrote:
gt; I think you need to explain how that shows up as black, as a score of 81
gt; would push the 2 round score well above par.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Tommyquot; gt; wrote in message
gt; ...
gt; gt; When I use that if the score is 81 in the first round the total shows up
gt; in
gt; gt; red i need it to show up in black.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Wouldn't you check total against 2 times par?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I have a golf spreadsheet for scores if the score is under par the
gt; color
gt; gt; gt; is
gt; gt; gt; gt; red if it is par or over it is black. I have two scores columa's and
gt; a
gt; gt; gt; total
gt; gt; gt; gt; columa. When I do this the total columa will use the 1st score red or
gt; the
gt; gt; gt; gt; 2nd score columa. So the total is not the right color. Please help.
gt; I
gt; gt; gt; use
gt; gt; gt; gt; a columa that I can change the par for each course. So my forumula
gt; has
gt; gt; gt; the
gt; gt; gt; gt; par in it everytime.
gt; gt; gt; gt;
gt; gt; gt; gt; name score score total
gt; gt; gt; gt; player 71 72 143
gt; gt; gt; gt; red black red
gt; gt; gt; gt; player 73 71 144
gt; gt; gt; gt; black red black
gt; gt; gt; gt;
gt; gt; gt; gt; This is how it should look, of course the numbers or in color not the
gt; gt; gt; color
gt; gt; gt; gt; written under the number.
gt; gt; gt; gt;
gt; gt; gt; gt; Thank You
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;
Tommy, you need different CF for scores and total. The score should show
black for 72 and above, red for below. The total should show red for 144 and
above, black below. Or at least that is how I se it.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Tommyquot; gt; wrote in message
...
gt; Bob
gt;
gt; Sorry for all the trouble. But when I put a score in the first round
above
gt; par which is 72, it shows up red in the total column, it needs to show up
in
gt; black. Red is under par and black is par or above. When I use the 2x it
gt; works at the two rounds are complete. I'm just trying to get the total to
gt; look right after the first round.
gt;
gt; thank you
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; I think you need to explain how that shows up as black, as a score of 81
gt; gt; would push the 2 round score well above par.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; When I use that if the score is 81 in the first round the total shows
up
gt; gt; in
gt; gt; gt; red i need it to show up in black.
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Wouldn't you check total against 2 times par?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; I have a golf spreadsheet for scores if the score is under par
the
gt; gt; color
gt; gt; gt; gt; is
gt; gt; gt; gt; gt; red if it is par or over it is black. I have two scores columa's
and
gt; gt; a
gt; gt; gt; gt; total
gt; gt; gt; gt; gt; columa. When I do this the total columa will use the 1st score
red or
gt; gt; the
gt; gt; gt; gt; gt; 2nd score columa. So the total is not the right color. Please
help.
gt; gt; I
gt; gt; gt; gt; use
gt; gt; gt; gt; gt; a columa that I can change the par for each course. So my
forumula
gt; gt; has
gt; gt; gt; gt; the
gt; gt; gt; gt; gt; par in it everytime.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; name score score total
gt; gt; gt; gt; gt; player 71 72 143
gt; gt; gt; gt; gt; red black red
gt; gt; gt; gt; gt; player 73 71 144
gt; gt; gt; gt; gt; black red black
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; This is how it should look, of course the numbers or in color not
the
gt; gt; gt; gt; color
gt; gt; gt; gt; gt; written under the number.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thank You
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
Bob
that is correct, I have cf for scores and it works, but I can't get the
total to work. Can you help me with that. In the total column it would be
any score below par is in red, so 71 and below and 143 and below. I can't
get this part to work. i total is either always red or black. I think I
would need more than 3 cf in the total column.
Thank you
quot;Bob Phillipsquot; wrote:
gt; Tommy, you need different CF for scores and total. The score should show
gt; black for 72 and above, red for below. The total should show red for 144 and
gt; above, black below. Or at least that is how I se it.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Tommyquot; gt; wrote in message
gt; ...
gt; gt; Bob
gt; gt;
gt; gt; Sorry for all the trouble. But when I put a score in the first round
gt; above
gt; gt; par which is 72, it shows up red in the total column, it needs to show up
gt; in
gt; gt; black. Red is under par and black is par or above. When I use the 2x it
gt; gt; works at the two rounds are complete. I'm just trying to get the total to
gt; gt; look right after the first round.
gt; gt;
gt; gt; thank you
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; I think you need to explain how that shows up as black, as a score of 81
gt; gt; gt; would push the 2 round score well above par.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; When I use that if the score is 81 in the first round the total shows
gt; up
gt; gt; gt; in
gt; gt; gt; gt; red i need it to show up in black.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Wouldn't you check total against 2 times par?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; I have a golf spreadsheet for scores if the score is under par
gt; the
gt; gt; gt; color
gt; gt; gt; gt; gt; is
gt; gt; gt; gt; gt; gt; red if it is par or over it is black. I have two scores columa's
gt; and
gt; gt; gt; a
gt; gt; gt; gt; gt; total
gt; gt; gt; gt; gt; gt; columa. When I do this the total columa will use the 1st score
gt; red or
gt; gt; gt; the
gt; gt; gt; gt; gt; gt; 2nd score columa. So the total is not the right color. Please
gt; help.
gt; gt; gt; I
gt; gt; gt; gt; gt; use
gt; gt; gt; gt; gt; gt; a columa that I can change the par for each course. So my
gt; forumula
gt; gt; gt; has
gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; par in it everytime.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; name score score total
gt; gt; gt; gt; gt; gt; player 71 72 143
gt; gt; gt; gt; gt; gt; red black red
gt; gt; gt; gt; gt; gt; player 73 71 144
gt; gt; gt; gt; gt; gt; black red black
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; This is how it should look, of course the numbers or in color not
gt; the
gt; gt; gt; gt; gt; color
gt; gt; gt; gt; gt; gt; written under the number.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thank You
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;
Tommy,
Is there any way you can set a range that tells you this must be a single
round score, or a total. For instance, we know that less than 71 is a single
round (no-one is that good to only score 71 in 2 rounds :-), and maybe say
anything over 120 is 2 rounds. If so you could then use
=OR(A1lt;=71, AND(A1gt; 120,A1lt;=143))
and set that to red. Will that work for you?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Tommyquot; gt; wrote in message
...
gt; Bob
gt;
gt; that is correct, I have cf for scores and it works, but I can't get the
gt; total to work. Can you help me with that. In the total column it would
be
gt; any score below par is in red, so 71 and below and 143 and below. I
can't
gt; get this part to work. i total is either always red or black. I think I
gt; would need more than 3 cf in the total column.
gt;
gt; Thank you
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Tommy, you need different CF for scores and total. The score should show
gt; gt; black for 72 and above, red for below. The total should show red for 144
and
gt; gt; above, black below. Or at least that is how I se it.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Bob
gt; gt; gt;
gt; gt; gt; Sorry for all the trouble. But when I put a score in the first round
gt; gt; above
gt; gt; gt; par which is 72, it shows up red in the total column, it needs to show
up
gt; gt; in
gt; gt; gt; black. Red is under par and black is par or above. When I use the 2x
it
gt; gt; gt; works at the two rounds are complete. I'm just trying to get the
total to
gt; gt; gt; look right after the first round.
gt; gt; gt;
gt; gt; gt; thank you
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I think you need to explain how that shows up as black, as a score
of 81
gt; gt; gt; gt; would push the 2 round score well above par.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; When I use that if the score is 81 in the first round the total
shows
gt; gt; up
gt; gt; gt; gt; in
gt; gt; gt; gt; gt; red i need it to show up in black.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Wouldn't you check total against 2 times par?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; gt; I have a golf spreadsheet for scores if the score is under
par
gt; gt; the
gt; gt; gt; gt; color
gt; gt; gt; gt; gt; gt; is
gt; gt; gt; gt; gt; gt; gt; red if it is par or over it is black. I have two scores
columa's
gt; gt; and
gt; gt; gt; gt; a
gt; gt; gt; gt; gt; gt; total
gt; gt; gt; gt; gt; gt; gt; columa. When I do this the total columa will use the 1st
score
gt; gt; red or
gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; 2nd score columa. So the total is not the right color.
Please
gt; gt; help.
gt; gt; gt; gt; I
gt; gt; gt; gt; gt; gt; use
gt; gt; gt; gt; gt; gt; gt; a columa that I can change the par for each course. So my
gt; gt; forumula
gt; gt; gt; gt; has
gt; gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; par in it everytime.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; name score score total
gt; gt; gt; gt; gt; gt; gt; player 71 72 143
gt; gt; gt; gt; gt; gt; gt; red black red
gt; gt; gt; gt; gt; gt; gt; player 73 71 144
gt; gt; gt; gt; gt; gt; gt; black red black
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; This is how it should look, of course the numbers or in color
not
gt; gt; the
gt; gt; gt; gt; gt; gt; color
gt; gt; gt; gt; gt; gt; gt; written under the number.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Thank You
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
Bob
That Worked great. Thank You for your help.
Tommy
quot;Bob Phillipsquot; wrote:
gt; Tommy,
gt;
gt; Is there any way you can set a range that tells you this must be a single
gt; round score, or a total. For instance, we know that less than 71 is a single
gt; round (no-one is that good to only score 71 in 2 rounds :-), and maybe say
gt; anything over 120 is 2 rounds. If so you could then use
gt;
gt; =OR(A1lt;=71, AND(A1gt; 120,A1lt;=143))
gt;
gt; and set that to red. Will that work for you?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Tommyquot; gt; wrote in message
gt; ...
gt; gt; Bob
gt; gt;
gt; gt; that is correct, I have cf for scores and it works, but I can't get the
gt; gt; total to work. Can you help me with that. In the total column it would
gt; be
gt; gt; any score below par is in red, so 71 and below and 143 and below. I
gt; can't
gt; gt; get this part to work. i total is either always red or black. I think I
gt; gt; would need more than 3 cf in the total column.
gt; gt;
gt; gt; Thank you
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Tommy, you need different CF for scores and total. The score should show
gt; gt; gt; black for 72 and above, red for below. The total should show red for 144
gt; and
gt; gt; gt; above, black below. Or at least that is how I se it.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Bob
gt; gt; gt; gt;
gt; gt; gt; gt; Sorry for all the trouble. But when I put a score in the first round
gt; gt; gt; above
gt; gt; gt; gt; par which is 72, it shows up red in the total column, it needs to show
gt; up
gt; gt; gt; in
gt; gt; gt; gt; black. Red is under par and black is par or above. When I use the 2x
gt; it
gt; gt; gt; gt; works at the two rounds are complete. I'm just trying to get the
gt; total to
gt; gt; gt; gt; look right after the first round.
gt; gt; gt; gt;
gt; gt; gt; gt; thank you
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I think you need to explain how that shows up as black, as a score
gt; of 81
gt; gt; gt; gt; gt; would push the 2 round score well above par.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; When I use that if the score is 81 in the first round the total
gt; shows
gt; gt; gt; up
gt; gt; gt; gt; gt; in
gt; gt; gt; gt; gt; gt; red i need it to show up in black.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Wouldn't you check total against 2 times par?
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; quot;Tommyquot; gt; wrote in message
gt; gt; gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; gt; gt; I have a golf spreadsheet for scores if the score is under
gt; par
gt; gt; gt; the
gt; gt; gt; gt; gt; color
gt; gt; gt; gt; gt; gt; gt; is
gt; gt; gt; gt; gt; gt; gt; gt; red if it is par or over it is black. I have two scores
gt; columa's
gt; gt; gt; and
gt; gt; gt; gt; gt; a
gt; gt; gt; gt; gt; gt; gt; total
gt; gt; gt; gt; gt; gt; gt; gt; columa. When I do this the total columa will use the 1st
gt; score
gt; gt; gt; red or
gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; gt; 2nd score columa. So the total is not the right color.
gt; Please
gt; gt; gt; help.
gt; gt; gt; gt; gt; I
gt; gt; gt; gt; gt; gt; gt; use
gt; gt; gt; gt; gt; gt; gt; gt; a columa that I can change the par for each course. So my
gt; gt; gt; forumula
gt; gt; gt; gt; gt; has
gt; gt; gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; gt; par in it everytime.
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; name score score total
gt; gt; gt; gt; gt; gt; gt; gt; player 71 72 143
gt; gt; gt; gt; gt; gt; gt; gt; red black red
gt; gt; gt; gt; gt; gt; gt; gt; player 73 71 144
gt; gt; gt; gt; gt; gt; gt; gt; black red black
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; This is how it should look, of course the numbers or in color
gt; not
gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; color
gt; gt; gt; gt; gt; gt; gt; gt; written under the number.
gt; gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; gt; Thank You
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;
留言列表
