+ Reply to Thread
Results 1 to 6 of 6

Need to apply conditional formatting of a cell base on text in multiple other cells

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    Corona, CA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Angry Need to apply conditional formatting of a cell base on text in multiple other cells

    I'm trying to have the color of a cell change if a string of text appears in any of several other columns.

    For example:

    A4: Don
    Conditionally Format A4 to change to yellow if "Awaiting Action" appears in any of the columns K4-N4.

    I keep trying =A4($K4:$N4="Awaiting Action") and nothing happens. I've tried a few iterations of this and still nothing or I get a "Hey dummy this isn't a formula, maybe you want this to be only text" error.

    This also needs to be able to retain its formatting after being linked into a powerpoint. And If there is an easy way to Copy and Paste this formatting to other cells so someone other than me can just add the info and have it update automatically instead of letting someone else mess with the formatting and screw it up later?

    Thanks. I've been pulling my hair out for the last 4 hours trying to figure this one out. My newly receding hairline and I appreciate your help.

    FTFTRACKER 2.xlsx

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need to apply conditional formatting of a cell base on text in multiple other cells

    Try this...

    =MATCH("Awaiting Action",$K4:$N4,0)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,095

    Re: Need to apply conditional formatting of a cell base on text in multiple other cells

    Hello & Welcome to the Forum,

    Try...

    Conditional Formatting
    • Highlight applicable range >> A2:A14
    • Home Tab >> Styles >> Conditional Formatting
    • New Rule >> Use a formula to determine which cells to format
    • Edit the Rule Description: Format values where this formula is true: =COUNTIF($K2:$N2,"Awaiting Action")
    • Formatů [Number, Font, Border, Fill]
    • OK >> OK
    HTH
    Regards, Jeff

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,420

    Re: Need to apply conditional formatting of a cell base on text in multiple other cells

    Hi, and welcome to the forum.

    See attached
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    09-19-2013
    Location
    Corona, CA
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Need to apply conditional formatting of a cell base on text in multiple other cells

    Thanks guys... 3 ways to go about it and they all work.. You guys rock.

  6. #6
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need to apply conditional formatting of a cell base on text in multiple other cells

    You're welcome. We appreciate the feedback!

+ 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] Conditional Formatting to apply to two cells
    By c.drysdale89 in forum Excel General
    Replies: 2
    Last Post: 01-25-2013, 08:26 AM
  2. [SOLVED] Conditional Formatting Apply to multiple Cells
    By ganesh81289 in forum Excel General
    Replies: 4
    Last Post: 06-22-2012, 11:08 PM
  3. Replies: 4
    Last Post: 10-17-2011, 11:01 AM
  4. Replies: 3
    Last Post: 04-30-2011, 11:46 PM
  5. How do I apply conditional formatting to a text box
    By barneshere in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2005, 02:05 PM

Tags for this Thread

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