+ Reply to Thread
Results 1 to 9 of 9

Applying a rule to all ROWS issue

  1. #1
    Registered User
    Join Date
    07-21-2020
    Location
    UK
    MS-Off Ver
    365
    Posts
    16

    Applying a rule to all ROWS issue

    Hello All,
    I'm new to Excel and have hit an issue that i'm sure is very easy to correct, but has me stuck.
    I have a simple macro in VBA that changes a cell value based on a different cell's value. I need to apply this rule to all columns in my worksheet:

    If Range("I4").VALUE = "Text 1" Then Range("J4").VALUE = "Yes"
    If Range("I4").VALUE = "Text 2" Then Range("J4").VALUE = "No"


    Any help would be appreciated.

    Most kind.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,557

    Re: Applying a rule to all ROWS issue



    Not sure what you mean by all columns, but is this on the right track?
    Please Login or Register  to view this content.
    ____________________________________________________________
    If I've been helpful, let me know. If I haven't, let me know that too.

  3. #3
    Registered User
    Join Date
    07-21-2020
    Location
    UK
    MS-Off Ver
    365
    Posts
    16

    Re: Applying a rule to all ROWS issue

    Hi dangelor,
    Many thanks for your reply.
    I'll need to run that when I have a bit more time to experiment.
    What i'm trying to do is apply a rule to all columns i.e Cell I4 text changes J4; I5 changes J5; I6 changes J6 and so on for several thousand.
    If your formula is correct then please accept my sincerest gratitude.
    Most kind.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,557

    Re: Applying a rule to all ROWS issue

    It should do as you say, but first try it on a copy of your data.

  5. #5
    Registered User
    Join Date
    07-21-2020
    Location
    UK
    MS-Off Ver
    365
    Posts
    16

    Re: Applying a rule to all ROWS issue

    Hello again,
    I have tried your suggestion but it didn't work sorry. Would you be kind enough to suggest another solution please?

    Kind regards
    Mary

  6. #6
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,481

    Re: Applying a rule to all ROWS issue

    Posted in the wrong forum (VBA)

  7. #7
    Registered User
    Join Date
    08-29-2020
    Location
    annaba
    MS-Off Ver
    2016
    Posts
    12

    Re: Applying a rule to all ROWS issue

    What I've done is format the negative numbers after entering them






    Tutuapp 9apps Showbox
    Last edited by amelbeabk; 09-04-2020 at 07:53 PM.

  8. #8
    Registered User
    Join Date
    08-29-2020
    Location
    annaba
    MS-Off Ver
    2016
    Posts
    12

    Re: Applying a rule to all ROWS issue

    Quote Originally Posted by amelbeabk View Post
    What I've done is format the negative numbers after entering them
    The fourth type of module is a class module, which allow you to create your own classes. Events for these modules are defined in the body of the module. To insert one, right click as above, Insert > Class Module

  9. #9
    Registered User
    Join Date
    07-21-2020
    Location
    UK
    MS-Off Ver
    365
    Posts
    16

    Re: Applying a rule to all ROWS issue

    Many thanks for your help, but I cant see the formula that you have written when I click the link.

+ 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] Data Validation Rule: Not Function with Exceptions to the rule
    By KidZest in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2019, 11:45 PM
  2. [SOLVED] Generate Rows by a rule
    By alizh in forum Excel General
    Replies: 6
    Last Post: 09-17-2019, 08:18 AM
  3. Replies: 5
    Last Post: 05-23-2019, 07:55 PM
  4. SUMPRODUCT - Applying a rule of precedence.
    By domgilberto in forum Excel General
    Replies: 6
    Last Post: 05-21-2014, 02:04 PM
  5. Highlighting cells rule issue
    By xrajncajnx in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-07-2014, 12:38 PM
  6. [SOLVED] Applying the INDIRECT or INDEX function on formula to solve #REF issue
    By Flight777 in forum Excel General
    Replies: 23
    Last Post: 05-24-2012, 09:23 AM
  7. Replies: 2
    Last Post: 03-17-2011, 02:51 AM

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