+ Reply to Thread
Results 1 to 6 of 6

Condition formating

  1. #1
    Registered User
    Join Date
    12-13-2010
    Location
    melbourne australia
    MS-Off Ver
    Excel 2016
    Posts
    46

    Condition formating

    Hi,

    I have a condition format that highlights a whole row if the text in a field is "Refresh". I use the formula below and it works well.

    =INDIRECT("E"&ROW())="refresh"

    The new issue i have is that i need to add numbers to the word refresh so it will now look like Refresh-1, Refresh-2,Refresh-3,Refresh-4 and so on...

    how do i use the same formula to highlight the row if the cell "contains" the word refresh?

    Thanks

    Viren

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,772

    Re: Condition formating

    untested...

    =INDIRECT("E"&ROW())="refresh*"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-13-2010
    Location
    melbourne australia
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Condition formating

    Hi FDibbins,

    Thanks for your prompt reply. "Refresh*" doesnt work. its the first thing i tried.
    thanks.

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Condition formating

    =ISNUMBER(SEARCH("refresh",INDIRECT("E"&ROW()))) or
    =LEFT(INDIRECT("E"&ROW()),7)="refresh"
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

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

    Re: Condition formating

    Try this...

    =SEARCH("Refresh",INDIRECT("E"&ROW()))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Registered User
    Join Date
    12-13-2010
    Location
    melbourne australia
    MS-Off Ver
    Excel 2016
    Posts
    46

    Re: Condition formating

    Hi Martin,

    Thanks for your solution. Perfect !!!. I used the left function.

    Viren

+ 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. CONDITIONAL FORMATING for more then one condition
    By rajeshturaha in forum Excel General
    Replies: 1
    Last Post: 07-30-2013, 09:07 AM
  2. Condition formating a cell in a worksheet based off formating of another cell
    By bdberger1985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2013, 05:52 PM
  3. Condition Formating
    By Hlowmaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2010, 04:31 PM
  4. [SOLVED] condition formating I think
    By Dreamstar_1961 in forum Excel General
    Replies: 3
    Last Post: 05-05-2006, 12:35 PM
  5. condition formating
    By chiuinggum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2006, 08:00 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