Conditional Format the cell. Formula is =d13="YES" then under format
change font color. Then add another condition for your no.
Here's the link to explain it better.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
"Kev" wrote:
How do I Change the colour Of "YES" To Blue and "NO" to red