Results 1 to 16 of 16

Conditional Formatting Issues when adding new rows

Threaded View

  1. #1
    Registered User
    Join Date
    04-06-2016
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    18

    Conditional Formatting Issues when adding new rows

    Hello, I have written quite a few rules for a large database of information that changes the colour of the row depending on various conditions. This is all working perfectly right now, BUT... when a new row is inserted, I need all of the conditional formatting (and formulae in certain columns) to apply to the new row too. At the moment, when I insert a new row, it changes the colour of SOME of the existing rows. So, when I insert a new row underneath row 17, the colour of row 21 changes from purple to red when it should stay as it was. Is this an issue with my conditional formatting or with the formulae in the cells?

    And example of a conditional format is as follows:

    Rule: =AND($AH14>0,$AG14>0,$AI14<>0)
    Format: Changes row to red
    Applies to: =A14:AI3000


    Please can anyone spot my error? The document is huge and contains 12 worksheets which all interact with each other. This is why I haven't uploaded it yet. I can't really split it but could upload the whole thing if the information above isn't enough.

    Thank you in advance...
    Last edited by curdley; 04-22-2016 at 07:30 AM. Reason: attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting Issues
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-05-2016, 05:55 PM
  2. Replies: 7
    Last Post: 06-20-2015, 02:12 PM
  3. Inserting/Deleting Rows Causes Issues with Conditional Formatting Macro
    By lashellr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2014, 01:25 PM
  4. Conditional Formatting when adding rows
    By airfrc1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-29-2014, 08:42 AM
  5. Replies: 8
    Last Post: 11-26-2013, 07:37 PM
  6. lose range conditional formatting adding/deleting rows
    By mrodenkirch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-29-2013, 12:46 PM
  7. Issues with formula when adding/subtracting rows
    By hektisk in forum Excel General
    Replies: 1
    Last Post: 07-21-2011, 11:16 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