Results 1 to 4 of 4

Conditional Formating: Highlight Cells Based on Text of Another Cell

Threaded View

Fcroft Conditional Formating:... 08-28-2009, 10:42 AM
NBVC Re: Conditional Formating:... 08-28-2009, 10:58 AM
Fcroft Re: Conditional Formating:... 08-28-2009, 11:07 AM
NBVC Re: Conditional Formating:... 08-28-2009, 11:16 AM
  1. #1
    Registered User
    Join Date
    08-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    57

    Conditional Formating: Highlight Cells Based on Text of Another Cell

    Hey everyone, I've been trying to figure out how to do this certian function for the last hour, with no real progress. I appologize if this is in the wrong section. What I'm trying to do is this:

    I have created a drop down box that allows me to choose multiple different Text Options.

    Example: Cell B4 has dropdown that lets me choose the Text Options, "House", "Car" and "Truck".

    Next, I have 5 or so other columns underneath with their own text. What I want to do is have different cells highlight themselves depending on what is in Cell B4.

    Example, if "House" is selected in B4, I want cells B7 and B9 to highlight. If "Car" is selected, I want cells B7, B8, and B10 to highlight. If "Truck" is highlighted, I want cells B9-B11 to highlight.

    Is this possible to do? I've tried using If/Then statements, but those don't seem to work for this type of thing.

    Any help would be greatly appreciated. Also, I am using Excel 2007.
    Last edited by Fcroft; 08-28-2009 at 11:59 AM.

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