How do I Change the colour Of "YES" To Blue and "NO" to red
B Bob Phillips Dec 17, 2005 #2 Look up Conditional Formatting in help, it does that sort of thing. -- HTH RP (remove nothere from the email address if mailing direct)
Look up Conditional Formatting in help, it does that sort of thing. -- HTH RP (remove nothere from the email address if mailing direct)
T TC Dec 17, 2005 #3 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
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
