See
http://www.contextures.com/xlCondFormat01.html
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"ratboy1013" wrote in message
...
I work in television and have a long report that pulls ratings for a
number
of shows on a number of different stations. I want to be able to change
the
color of an entire show depending on the station. For example, if program
airs on station A change the font color of the entire row to red, if
program
airs on station B change the entire row to blue, if program airs on
station C
change the entire row to green.