Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel IF Function (2000)

    Is there a way to use the IF function and have the true result appear in one color and the false in another???

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel IF Function (2000)

    Functions cannot set formatting. Depending on what the formula returns, you may be able to use a number format or conditional formatting to do what you want.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel IF Function (2000)

    You would need to use conditional formatting to do that. Could you show us the IF statement. If you can, then we can probably tell you how to do the conditional formatting.
    Legare Coleman

Posting Permissions

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