+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting of specific words in seperate cells

  1. #1
    Registered User
    Join Date
    03-24-2012
    Location
    Puyallup, WA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Conditional formatting of specific words in seperate cells

    So I've been looking all over online trying to find a way to do this, but basically I have a cell that needs to turn red if it contains a specific text, and if another cell contains a different specific test.

    If column D says "CD" and column E says "Frag" I need column E to appear red. Any help would be really appreciated. Thanks!

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Conditional formatting of specific words in seperate cells

    Hi Jeresous, welcome to the forum.

    Select column E (or just a range, like E1:E20) and set the Conditional Formatting formula to:

    =AND($D1="CD",$E1="Frag")

    This assumes your starting in row 1. Hope that helps!

  3. #3
    Registered User
    Join Date
    03-24-2012
    Location
    Puyallup, WA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Conditional formatting of specific words in seperate cells

    Thanks for the welcome, and for the help. I'm still having a bit of trouble with this however. I tried applying it to a new excel document and only involving row 1 as depicted in your formula, and it worked fine. However, when I tried to utilize it in the workbook I'm trying to create I couldn't get it to work with full columns or even with just trying to have it impact the first 2000 rows.

    Here is what my conditional formatting looks like now:

    =AND($D1:$D2000="CD",$G1:$G2000="Frag")

    The best I can figure is that it's condition is trying to check if every single row has that identical data. Is there an easy way to get the condition to apply to all the rows independently without setting a conditional format for every single row?

  4. #4
    Registered User
    Join Date
    03-24-2012
    Location
    Puyallup, WA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Conditional formatting of specific words in seperate cells

    Disregard. I noticed my mistake. I didn't select the column I wanted to change colors prior to entering the formula as you specified in your instructions. Thanks again for the help.

+ 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