+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting of one row applied to other rows

  1. #1
    Registered User
    Join Date
    10-04-2015
    Location
    Romania
    MS-Off Ver
    2007,2013
    Posts
    11

    Conditional formatting of one row applied to other rows

    Hi ,

    I have a question on how to apply conditional formatting of one row to other rows without using format painter ? The issue is that a have over 100k rows.

    To be more specific i attached a sample .
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,642

    Re: Conditional formatting of one row applied to other rows

    First find the last used cell with F5
    Then Conditional Formatting - Manage rules - replace the end reference in the range in the " applies to" box with the last used you found

  3. #3
    Registered User
    Join Date
    08-22-2015
    Location
    Dhaka
    MS-Off Ver
    office 8
    Posts
    33

    Re: Conditional formatting of one row applied to other rows

    Go to conditional formating>manage rule>applies to>>

    and then change the range, i mean select all the data from the worksheet on which you want to apply the rule.

  4. #4
    Registered User
    Join Date
    10-04-2015
    Location
    Romania
    MS-Off Ver
    2007,2013
    Posts
    11

    Re: Conditional formatting of one row applied to other rows

    if i select all data range , then the conditional formatting applies to all data.It`s not what i want.I need conditional formatting for one row , such as the sample attach , where for "Avec MM Impex SRL" the data is compared using the range c2:e2, i want the same formatting for "PRIMERO BUSINESS CONSULTING" range C3:E3.I can use format painter but i have 100k rows.I`m asking for another easy option.

    Sorry if i`m not to good to explain what i need.

  5. #5
    Registered User
    Join Date
    10-04-2015
    Location
    Romania
    MS-Off Ver
    2007,2013
    Posts
    11

    Re: Conditional formatting of one row applied to other rows

    Can you help me with a solution in this matter ?

+ 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. Replies: 11
    Last Post: 02-03-2015, 04:16 AM
  2. Replies: 1
    Last Post: 10-29-2014, 12:44 AM
  3. Detecting if a cell has conditional formatting applied to it
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2013, 01:37 PM
  4. [SOLVED] Highlight cells that have conditional formatting applied to them....
    By Thistledown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2012, 09:09 AM
  5. How to changing conditional formatting once applied
    By mgia0055 in forum Excel General
    Replies: 5
    Last Post: 10-13-2010, 08:15 AM
  6. can conditional formatting be applied in more then three instance
    By Mary jane in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-21-2005, 12:10 AM
  7. How do I determine if conditional formatting is applied to an exc.
    By MarkTheNuke in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

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