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

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

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

--

HTH

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


"Kev" <[email protected]> wrote in message
news:[email protected]...
> How do I Change the colour Of "YES" To Blue and "NO" to red

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

Cell Value is equal To Yes



"Kev" wrote:

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