+ Reply to Thread
Results 1 to 2 of 2

Change Cell Background Color Depening on Text

  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    WI
    Posts
    1

    Change Cell Background Color Depening on Text

    I am looking for a way to have the background color of a cell change depending what is typed into it. For example, if "SLK" is typed in, I want it to turn green. I have about 8 possible values that would be entered that need to change it to a particular background color. Ideally, I would like to have it so that the color isn't hard coded, but it rather pulls the color from a reference cell. That way, I can change the color of a reference cell and it will change it throughout the whole worksheet.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    XL07 could do it with conditional formatting.

    If XL07 is not an option, you will need to use a change event and a macro that would check all if you decide to change colors without cell modification. See http://vbaexpress.com/forum/showthread.php?t=22084

+ 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