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. 08-13-2017, 01:20 PM #7
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2508
    Posts
    19,575

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

    Perhaps using the following formula for the 'Refers to:', as prescribed in this article, would work better:
    Formula: copy to clipboard 
    =OFFSET(TASKS!$F$12,0,0,COUNTA(TASKS!$A$12:$A$201),1)

    Let us know if you have any questions.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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. [SOLVED] Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Additional Conditions for Conditional Formatting
    By eric beck in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1