+ Reply to Thread
Results 1 to 4 of 4

Format text to display as a result of two other cell inputs. Numerous combinations.

  1. #1
    Registered User
    Join Date
    05-31-2014
    Posts
    2

    Format text to display as a result of two other cell inputs. Numerous combinations.

    Hello,

    Apologies if the title is too vague I am having trouble describing what it is that I am trying to do correctly and may need to adjust the title with some assistance.

    I am using a spreadsheet to assist with the flow of numerous projects taking place at my workplace. The projects have different stages and requirements along the way which need to be completed at certain times to ensure the smooth sailing of the project. This particular section of the sheet is used to identify if a project is late with a certain requirement and if this is the case to place a RED TEXT in a cell next to the project listing.

    Rules:
    When a project has reached 'Business Case' Phase then it is a requirement for certain documents to be completed. If the project moves along to the next phase without these documents being completed then the project will receive a red alert.

    I am trying to create a formula which will read the cell that displays the stage of the project along with whether the documents have been completed and then rate the project with a specific word ie: Red, Green, Amber in the cell next to these inputs.

    A1=Business Case and B1=empty then C1="AMBER, you must complete documentation before moving on"
    A1=Design and B1=empty then C1="RED, you are late with documentation"
    A1=Design and B1="Complete" then C1="GREEN, you are up to date with documentation"

    I am able to get a formula that will read both cells and then provide an outcome in the third cell but am unsure how I can add the second rule and so on into this

    This is what I have so far...

    Please Login or Register  to view this content.
    I think I need to include OR function in here but am unsure how.

    Came up with something along the lines of:

    Please Login or Register  to view this content.
    Does not work. . .

    I have attached the proposed rules in further detail to give further understanding of what it is that I need. I am not sure whether it is possible to format cell with this many rules.

    Any assistance with this would be greatly appreciated.

    Best Regards,conditional formatting register.xlsx
    Last edited by Lucbrown; 05-31-2014 at 11:13 PM.

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Format text to display as a result of two other cell inputs. Numerous combinations.

    Quote Originally Posted by Lucbrown View Post
    A1=Business Case and B1=empty then C1="AMBER, you must complete documentation before moving on"
    A1=Design and B1=empty then C1="RED, you are late with documentation"
    A1=Design and B1="Complete" then C1="GREEN, you are up to date with documentation"
    Hi Lucas,

    Welcome to the Forum.

    Looks like your requirement can be fulfilled with the aid of an helper column (can be hidden). We need to code IF condition and based on the value returned by the condition, we need to apply conditional formatting.

    As you have quoted above, could you confirm if these are the only combinations for Green, Amber and Red ? Can you provide the entire list of possible combinations to code the IF condition ? Coz, in your worksheet, I find that you have other combinations as well.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  3. #3
    Registered User
    Join Date
    05-31-2014
    Posts
    2

    Re: Format text to display as a result of two other cell inputs. Numerous combinations.

    Quote Originally Posted by Saarang84 View Post


    Hi Lucas,

    Welcome to the Forum.

    Looks like your requirement can be fulfilled with the aid of an helper column (can be hidden). We need to code IF condition and based on the value returned by the condition, we need to apply conditional formatting.

    As you have quoted above, could you confirm if these are the only combinations for Green, Amber and Red ? Can you provide the entire list of possible combinations to code the IF condition ? Coz, in your worksheet, I find that you have other combinations as well.

    Thankyou Saarang,

    The attached spreadsheet displays all possible outcomes.

    There are numerous combinations that could result in a green rating as well as the other possible ratings.

    Is that what you are asking?

  4. #4
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Format text to display as a result of two other cell inputs. Numerous combinations.

    Have you missed uploading the attachment? Could you edit your post and upload it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to format cell to display bottom text
    By aldmph in forum Excel General
    Replies: 7
    Last Post: 10-10-2019, 02:34 AM
  2. IF cell contains a certain item of text then display result
    By LMW1985 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-23-2013, 07:10 AM
  3. Display formula result if cell is X cells away from text value
    By jimmygig in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2013, 08:30 PM
  4. Display numerical result of a cell with Text as well
    By davidcrawt in forum Excel General
    Replies: 3
    Last Post: 11-26-2012, 03:27 PM
  5. Display text in cell in large format
    By sparx in forum Excel General
    Replies: 1
    Last Post: 04-17-2007, 09:33 AM

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