+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Kev
    Guest

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

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

  2. #2
    Bob Phillips
    Guest

    Re: =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" <Kev@discussions.microsoft.com> wrote in message
    news:805AB2EB-2A35-4F3F-BB8F-D04239904000@microsoft.com...
    > How do I Change the colour Of "YES" To Blue and "NO" to red




  3. #3
    TC
    Guest

    RE: =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


  4. #4
    exceluserforeman
    Guest

    RE: =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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1