+ Reply to Thread
Results 1 to 2 of 2

Using Find and Replace to change fill colors for rows containing that value

  1. #1
    Registered User
    Join Date
    02-11-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    6

    Using Find and Replace to change fill colors for rows containing that value

    I would like to change the fill color of all rows in a sheet that contain a certain word. I am unable to figure out how to do so using Find to search for the word and then using Replace.

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Using Find and Replace to change fill colors for rows containing that value

    Hi tmc1284,

    I used Conditional Formatting to fill colors that match criteria value.
    Please check attached file.

    Regards,
    AM

+ 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. find and replace non-standard colors
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 03-19-2015, 05:09 PM
  2. Upon entry in any cell, need some fill colors to change if certain conditions met
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2014, 02:25 AM
  3. [SOLVED] Cell fill colors in Excel change when copying to a new book
    By jkbond67 in forum Excel General
    Replies: 2
    Last Post: 07-31-2006, 04:53 PM
  4. [SOLVED] how to change colors in fill menu (Excel)
    By rp in forum Excel General
    Replies: 2
    Last Post: 04-17-2006, 06:30 PM
  5. Can I change the colors in the fill color chart?
    By Genesis Pat in forum Excel General
    Replies: 2
    Last Post: 03-28-2006, 02:55 PM

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