+ Reply to Thread
Results 1 to 4 of 4

If cells in row B8:D8 (for example) have any text, then enter "Changes" in column A8

Hybrid View

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    76

    Thumbs up If cells in row B8:D8 (for example) have any text, then enter "Changes" in column A8

    Hi.

    I have created a schedule sheet where one row indicates the closed schedule and below that row I want to show what has been changed.

    If anything shows up in the cell, I did a Conditional Formatting to change color so it would stand out. The thing is, I also want the word "Changes" to appear as a title for that particular row.

    ex:
    mon tue wed thur
    Jane Doe X no x x
    Changes x

    The word "Changes" should only appear if there were any changes made on that row (which I will add a conditional formatting to match the color of the changes under the days).

    The thing is, the change codes could be a number of choices. Its not just X and no....there is AANN, OT, TOP, etc. I don't know the whole list of choices.

    I tried: if(istext(D8:AB8),"Changes","") - which didn't work....

    Any help would be greatly appreciated!

    Thank you.

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

    Re: If cells in row B8:D8 (for example) have any text, then enter "Changes" in column A8

    Quote Originally Posted by Johfra View Post

    I tried: if(istext(D8:AB8),"Changes","") - which didn't work....
    This how you'd write that formula:

    =IF(COUNTIF(D8:AB8,"*"),"Changes","")

    That will test for any TEXT entries (does not test for numbers).

    The * is a wildcard meaning any TEXT entry.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    04-25-2013
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: If cells in row B8:D8 (for example) have any text, then enter "Changes" in column A8

    Thank you Tony! Works perfectly!

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

    Re: If cells in row B8:D8 (for example) have any text, then enter "Changes" in column A8

    You're welcome. Thanks for 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. Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"
    By jarious87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 03:30 PM
  2. Find "TEXT 1" in a range and enter "TEXT 2" in the adjacent cell
    By madreag in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2013, 05:34 PM
  3. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  4. Replies: 3
    Last Post: 04-14-2013, 11:53 PM
  5. How do I split "A1B2" into "A1" and "B2" using text to column fun.
    By Jennifer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2005, 06:06 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