Use Conditional formatting.
See
http://www.contextures.com/xlCondFormat01.html
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"CGaufin" wrote in message
...
Hello Excel users!
My wife is a teacher and she uses Excel to store her grades. I set up a
LOOKUP function for her to transform the students percentages into letter
grades. Is there a way to now use a conditional formula to changed the
text
color of the various letter grades? (ie: if grade is "F" then font color
equals red, if grade is "C" or "D" highlight in blue.) Any help would be
fantastic!
CGaufin