Results 1 to 4 of 4

Thread: Help: Change background if cell meets criteria

  1. #1

    Help: Change background if cell meets criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    is there a way to change the background color of a row if one column of that row contains specific text?

    please help. thanks.

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    Absolutely. You want Conditional Formatting.

    What version of Excel are you using? 2003 or lower, or 2007 or higher?
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    nice. am using 2007 higher

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,021
    Articles
    79
    Blog Entries
    14
    Okay, so here's how you do it:
    • Highlight the row you
    • Go to Home-->Conditional Formatting-->New Rule
    • Choose Use a formula to determine which cells to format
    • In the "Format values where this formula is true", enter a formula that checks the text, like this one: =$E$8="My Text" (Obviously you'll need to update for the correct cell reference and text)
    • Click Format-->Fill-->Choose your favourite colour
    • Click OK until you're back at the Excel grid, and you should be good to go.
    HTH,
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •