Results 1 to 11 of 11

Conditional formatting: adding rows adds additional conditions; how to avoid that?

Threaded View

Vitalite Conditional formatting:... 08-12-2017, 03:38 AM
JeteMc Re: Conditional formatting:... 08-12-2017, 05:38 PM
Vitalite Re: Conditional formatting:... 08-13-2017, 05:40 AM
Vitalite Re: Conditional formatting:... 08-13-2017, 06:50 AM
oeldere Re: Conditional formatting:... 08-13-2017, 06:57 AM
JeteMc Re: Conditional formatting:... 08-13-2017, 07:30 AM
JeteMc Re: Conditional formatting:... 08-13-2017, 01:20 PM
Vitalite Re: Conditional formatting:... 08-17-2017, 07:04 AM
Vitalite Re: Conditional formatting:... 08-17-2017, 08:26 AM
JeteMc Re: Conditional formatting:... 08-17-2017, 09:28 AM
Vitalite Re: Conditional formatting:... 08-21-2017, 12:19 PM
  1. #4
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

    Re: Conditional formatting: adding rows adds additional conditions; how to avoid that?

    I have found the brilliant template created by Vertex42 - a masterpiece, at least to me, who is just learning. )
    In it, whenever you add any row to any part of any sheet of the workbook, the conditional formatting rules' ranges neatly increment by the amount of rows you added, and do not create new rules for any added row (the problem I have in my file).
    How did they achieve that?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Additional Conditions for Conditional Formatting
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 11:05 AM
  2. Additional Conditions for Conditional Formatting
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 07:05 AM
  3. Additional Conditions for Conditional Formatting
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  4. Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. [SOLVED] Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2005, 02:05 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