+ Reply to Thread
Results 1 to 3 of 3

Thread: IF Function help

  1. #1
    Registered User
    Join Date
    06-23-2010
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    IF Function help

    I am trying to set up an IF function to return the values in different colors. example: im trying to set a suspense date. i have the function set to if the date is true then it will return "current" if its false it will return "over due" im trying to set it up so that the "over due" will show a red font color and the "current will show black. Please help im not sure how to get the fonts to change with the returns.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    6,202

    Re: IF Function help

    check this out.

    click on cells you want to format -> Conditional formatting
    Attached Images Attached Images
    "Relax. What is mind? No matter. What is matter? Never mind!"

  3. #3
    Registered User
    Join Date
    06-23-2010
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: IF Function help

    Thank you so much that is exactly what i needed!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.2.0