+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting that populates text as well as colour

Hybrid View

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    2

    Conditional Formatting that populates text as well as colour

    I want to be able to update a field to have a text value + colour based on the selection from 2 fields (that contain dropdown lists - I can set a rule to update colour but can't work out how to also populate it with texts

    So, Field C13 contains 3 values - e.g. A, B, C
    Field C14 contains 3 values - e.g. XYZ

    Field E14 should update to
    Yes and Green if values A and X are selected
    Maybe and Amber if values B and Y are selected
    No and Red if values C and Z are selected

    9 combinations in total

    Anyone can help?

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Conditional Formatting that populates text as well as colour

    just use the conditional formatting for the color and a worksheet function for the value.

    Since you already have the formatting, try this function.

    =CHOOSE(1+(C13="A")*(C14="X")*1+(C13="B")*(C14="Y")*2+(C13="C")*(C14="Z")*3,"","Yes","Maybe","No")
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    10-03-2014
    Location
    london
    MS-Off Ver
    2010
    Posts
    2

    Re: Conditional Formatting that populates text as well as colour

    Book3.xlsxThank you GeneralDisarray

    I'm not getting it quite right - maybe because I am using values from another field so references as opposed to hard coding values in the formula

    I've attached the doc

    Formula - =CHOOSE(1+($C$13=$B$9)*($C$14=$Y$1)*1+($C$13=$B$9)*($C$14=$Y$2)*2+($C$13=$B$9)*($C$14=$Y$3)*3,"","+$X$1","+$X$2","+$X$3") -- this would be extended to have 9 combinations once working

+ 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. [SOLVED] Counting Red Text Colour, When Applied by Conditional Formatting
    By Antligen in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-27-2014, 08:25 AM
  2. [SOLVED] Conditional Formatting, Changing Colour of Text
    By MatthewIJClark in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2013, 11:58 AM
  3. [SOLVED] Change cell colour based on text being present - conditional formatting?
    By rob-the-randy-rascal in forum Excel General
    Replies: 8
    Last Post: 08-01-2013, 11:24 AM
  4. Replies: 6
    Last Post: 05-19-2012, 06:51 AM
  5. Replies: 4
    Last Post: 12-21-2011, 11:32 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