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

Chuckers wrote:

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.

"Chip Pearson" wrote:

Take a look at Conditional Formatting on the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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




--

Dave Peterson