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. #1
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

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

    Hello!

    I am attaching the file and two screen shots, otherwise it will be hard to explain.

    In the tab called TASKS I have a set of conditional formatting rules, which initially extend from row 12 till row 42 (different columns for different rules).

    I hoped that adding a new row would extend the conditional formatting row range to 12 - 43, because one more row is added. It turns out not to be true.

    For example, if I want to insert a row between tasks 1.9 and 1.10, I do the following (in each case the formatting result is the same):

    1) copy 1.10
    click Insert copied cells
    get 1.10 on row 22 now
    the number of tasks is now 12 with the last one 1.12 (initially the last one was 1.11)

    2) add a new row between 1.9 and 1.10
    copy entire 1.9 (or 1.10) row
    paste copied row into a newly created one

    In both cases the result is the same. New conditional formatting rules are added (for the row 22), and the range of application of all initial rules is also changed - it is "split" now into a few ranges (see screen shot).

    How can I add rows and only extend the existing condition rules, without splitting the initial range and without getting new conditional rules?

    Thank you very much!
    Attached Images Attached Images
    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