=IF(D13="PAID","YES","NO") Can I change fonts colour
 

How do I Change the colour Of "YES" To Blue and "NO" to red

=IF(D13="PAID","YES","NO") Can I change fonts colour
 

Look up Conditional Formatting in help, it does that sort of thing.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kev" wrote in message
...
How do I Change the colour Of "YES" To Blue and "NO" to red

=IF(D13="PAID","YES","NO") Can I change fonts colour
 

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

=IF(D13="PAID","YES","NO") Can I change fonts colour
 

Cell Value is equal To Yes



"Kev" wrote:

How do I Change the colour Of "YES" To Blue and "NO" to red