+ Reply to Thread
Results 1 to 3 of 3

Add a background color to a cell depending on what you write

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    Bucuresti, Romania
    MS-Off Ver
    Excel 2003
    Posts
    2

    Exclamation Add a background color to a cell depending on what you write

    Who can help me?

    I want to add a background color to a cell depending on what I write.
    Ex:

    If I write "A", "B" or "C" the background color to be BLUE
    and if I write "D" or "E" the background color to be RED


    Thanks.

  2. #2
    Registered User
    Join Date
    02-17-2010
    Location
    Bucuresti, Romania
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Add a background color to a cell depending on what you write

    I solve the problem

    for those interested:
    With Conditional Formatting on the cell A1

    Condition 1
    Formula is =OR(A1="A";A1="B";A1="C")
    and put Blue color in format

    Condition 2
    Formula is =OR(A1="D";A1="E")
    and put Red color in format

    If anyone knows another way?
    Maybe in 1 condition not 2.

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Add a background color to a cell depending on what you write

    ady, I'm glad you found a solution. For your next post, please select one of the question forums. The feedback forum is not for questions about Excel.

    moved to Excel General

+ 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