software

Hello.
I I keep track of my bowling teams statistics. I type the scores in
columns C thru E rows 3 to 34. I have the formula for average in column H3
thru H34. When I type the scores in, I would like the color of the text to
be red for scores under average, black for scores from the average to 199,
and green from 200 and above. Is there anyway to do this automatically? I
am a new user.
Thank you very much.

Take a look at Conditional Formatting on the Format menu.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Chuckersquot; gt; wrote in message
...
gt; Hello.
gt; I I keep track of my bowling teams statistics. I type the
gt; scores in
gt; columns C thru E rows 3 to 34. I have the formula for average
gt; in column H3
gt; thru H34. When I type the scores in, I would like the color of
gt; the text to
gt; be red for scores under average, black for scores from the
gt; average to 199,
gt; and green from 200 and above. Is there anyway to do this
gt; automatically? I
gt; am a new user.
gt; Thank you very much.
Yes, I looked at that and tried a few things but couldn't figure out the
formula. Is there a place to learn about this?
Thank you.

quot;Chip Pearsonquot; wrote:

gt; Take a look at Conditional Formatting on the Format menu.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Chuckersquot; gt; wrote in message
gt; ...
gt; gt; Hello.
gt; gt; I I keep track of my bowling teams statistics. I type the
gt; gt; scores in
gt; gt; columns C thru E rows 3 to 34. I have the formula for average
gt; gt; in column H3
gt; gt; thru H34. When I type the scores in, I would like the color of
gt; gt; the text to
gt; gt; be red for scores under average, black for scores from the
gt; gt; average to 199,
gt; gt; and green from 200 and above. Is there anyway to do this
gt; gt; automatically? I
gt; gt; am a new user.
gt; gt; Thank you very much.
gt;
gt;
gt;

You could start with Excel's Help
or Debra Dalgleish's site:
www.contextures.com/xlCondFormat01.html

Chuckers wrote:
gt;
gt; Yes, I looked at that and tried a few things but couldn't figure out the
gt; formula. Is there a place to learn about this?
gt; Thank you.
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt; gt; Take a look at Conditional Formatting on the Format menu.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Cordially,
gt; gt; Chip Pearson
gt; gt; Microsoft MVP - Excel
gt; gt; Pearson Software Consulting, LLC
gt; gt; www.cpearson.com
gt; gt;
gt; gt;
gt; gt; quot;Chuckersquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hello.
gt; gt; gt; I I keep track of my bowling teams statistics. I type the
gt; gt; gt; scores in
gt; gt; gt; columns C thru E rows 3 to 34. I have the formula for average
gt; gt; gt; in column H3
gt; gt; gt; thru H34. When I type the scores in, I would like the color of
gt; gt; gt; the text to
gt; gt; gt; be red for scores under average, black for scores from the
gt; gt; gt; average to 199,
gt; gt; gt; and green from 200 and above. Is there anyway to do this
gt; gt; gt; automatically? I
gt; gt; gt; am a new user.
gt; gt; gt; Thank you very much.
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

Thanks very much. I think I've got it. I was able to do it for one row at a
time. I couldn't figure out how to all rows at the same time.

quot;Dave Petersonquot; wrote:

gt; You could start with Excel's Help
gt; or Debra Dalgleish's site:
gt; www.contextures.com/xlCondFormat01.html
gt;
gt; Chuckers wrote:
gt; gt;
gt; gt; Yes, I looked at that and tried a few things but couldn't figure out the
gt; gt; formula. Is there a place to learn about this?
gt; gt; Thank you.
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt; gt; Take a look at Conditional Formatting on the Format menu.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Cordially,
gt; gt; gt; Chip Pearson
gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; Pearson Software Consulting, LLC
gt; gt; gt; www.cpearson.com
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Chuckersquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Hello.
gt; gt; gt; gt; I I keep track of my bowling teams statistics. I type the
gt; gt; gt; gt; scores in
gt; gt; gt; gt; columns C thru E rows 3 to 34. I have the formula for average
gt; gt; gt; gt; in column H3
gt; gt; gt; gt; thru H34. When I type the scores in, I would like the color of
gt; gt; gt; gt; the text to
gt; gt; gt; gt; be red for scores under average, black for scores from the
gt; gt; gt; gt; average to 199,
gt; gt; gt; gt; and green from 200 and above. Is there anyway to do this
gt; gt; gt; gt; automatically? I
gt; gt; gt; gt; am a new user.
gt; gt; gt; gt; Thank you very much.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

If you select the whole range, you can write your format|conditional formatting
formula based on the activecell.

Excel will adjust the range--just like it does when you copy a formula down a
column.

If you select A1:Z99 (say)
and use this as your conditional formatting formula:
=$a1gt;6

It'll adjust the row for each row in that range (and won't adjust the column).

Chuckers wrote:
gt;
gt; Thanks very much. I think I've got it. I was able to do it for one row at a
gt; time. I couldn't figure out how to all rows at the same time.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You could start with Excel's Help
gt; gt; or Debra Dalgleish's site:
gt; gt; www.contextures.com/xlCondFormat01.html
gt; gt;
gt; gt; Chuckers wrote:
gt; gt; gt;
gt; gt; gt; Yes, I looked at that and tried a few things but couldn't figure out the
gt; gt; gt; formula. Is there a place to learn about this?
gt; gt; gt; Thank you.
gt; gt; gt;
gt; gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Take a look at Conditional Formatting on the Format menu.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; Cordially,
gt; gt; gt; gt; Chip Pearson
gt; gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; gt; Pearson Software Consulting, LLC
gt; gt; gt; gt; www.cpearson.com
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Chuckersquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; Hello.
gt; gt; gt; gt; gt; I I keep track of my bowling teams statistics. I type the
gt; gt; gt; gt; gt; scores in
gt; gt; gt; gt; gt; columns C thru E rows 3 to 34. I have the formula for average
gt; gt; gt; gt; gt; in column H3
gt; gt; gt; gt; gt; thru H34. When I type the scores in, I would like the color of
gt; gt; gt; gt; gt; the text to
gt; gt; gt; gt; gt; be red for scores under average, black for scores from the
gt; gt; gt; gt; gt; average to 199,
gt; gt; gt; gt; gt; and green from 200 and above. Is there anyway to do this
gt; gt; gt; gt; gt; automatically? I
gt; gt; gt; gt; gt; am a new user.
gt; gt; gt; gt; gt; Thank you very much.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Thank you, Thank you, thank you.
I selected cells C4 thru E34, I used condition 1, cell value is-greater
than-199,format green
condition 2, formula is C4lt;H3,format red
anything else is black.
worked like a charm.

quot;Dave Petersonquot; wrote:

gt; If you select the whole range, you can write your format|conditional formatting
gt; formula based on the activecell.
gt;
gt; Excel will adjust the range--just like it does when you copy a formula down a
gt; column.
gt;
gt; If you select A1:Z99 (say)
gt; and use this as your conditional formatting formula:
gt; =$a1gt;6
gt;
gt; It'll adjust the row for each row in that range (and won't adjust the column).
gt;
gt; Chuckers wrote:
gt; gt;
gt; gt; Thanks very much. I think I've got it. I was able to do it for one row at a
gt; gt; time. I couldn't figure out how to all rows at the same time.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; You could start with Excel's Help
gt; gt; gt; or Debra Dalgleish's site:
gt; gt; gt; www.contextures.com/xlCondFormat01.html
gt; gt; gt;
gt; gt; gt; Chuckers wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Yes, I looked at that and tried a few things but couldn't figure out the
gt; gt; gt; gt; formula. Is there a place to learn about this?
gt; gt; gt; gt; Thank you.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Take a look at Conditional Formatting on the Format menu.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Cordially,
gt; gt; gt; gt; gt; Chip Pearson
gt; gt; gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; gt; gt; Pearson Software Consulting, LLC
gt; gt; gt; gt; gt; www.cpearson.com
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Chuckersquot; gt; wrote in message
gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; Hello.
gt; gt; gt; gt; gt; gt; I I keep track of my bowling teams statistics. I type the
gt; gt; gt; gt; gt; gt; scores in
gt; gt; gt; gt; gt; gt; columns C thru E rows 3 to 34. I have the formula for average
gt; gt; gt; gt; gt; gt; in column H3
gt; gt; gt; gt; gt; gt; thru H34. When I type the scores in, I would like the color of
gt; gt; gt; gt; gt; gt; the text to
gt; gt; gt; gt; gt; gt; be red for scores under average, black for scores from the
gt; gt; gt; gt; gt; gt; average to 199,
gt; gt; gt; gt; gt; gt; and green from 200 and above. Is there anyway to do this
gt; gt; gt; gt; gt; gt; automatically? I
gt; gt; gt; gt; gt; gt; am a new user.
gt; gt; gt; gt; gt; gt; Thank you very much.
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; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Yes but it would be better to select the cells that you want to be affected first
i.e. entire columns, rather than coping formatting afterwards.
www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Chuckersquot; gt; wrote in message ...
gt; Thank you, Thank you, thank you.
gt; I selected cells C4 thru E34, I used condition 1, cell value is-greater
gt; than-199,format green
gt; condition 2, formula is C4lt;H3,format red
gt; anything else is black.
gt; worked like a charm.

Yes, I played around with it some more and what I ended up doing is selecting
all the cells and for condition 1: Formula is - =C3lt;ROUNDDOWN($H2,0) - format
red and condition 2: Cell Value is - gt;= 200 - format green.

Thank you very much for the reply.

quot;David McRitchiequot; wrote:

gt; Yes but it would be better to select the cells that you want to be affected first
gt; i.e. entire columns, rather than coping formatting afterwards.
gt; www.mvps.org/dmcritchie/excel/condfmt.htm
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Chuckersquot; gt; wrote in message ...
gt; gt; Thank you, Thank you, thank you.
gt; gt; I selected cells C4 thru E34, I used condition 1, cell value is-greater
gt; gt; than-199,format green
gt; gt; condition 2, formula is C4lt;H3,format red
gt; gt; anything else is black.
gt; gt; worked like a charm.
gt;
gt;
gt;
gt;

and that was with C3 as your active cell when you entered the formula, right,
because the active cell is the key to formula usage.

quot;Chuckersquot; gt; wrote
gt; Yes, I played around with it some more and what I ended up doing is selecting
gt; all the cells and for condition 1: Formula is - =C3lt;ROUNDDOWN($H2,0) - format
gt; red and condition 2: Cell Value is - gt;= 200 - format green.
gt;
gt; Thank you very much for the reply.