+ Reply to Thread
Results 1 to 3 of 3

conditional formating error in code

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Slovakia
    MS-Off Ver
    2007, 2010, 2013
    Posts
    76

    Angry conditional formating error in code

    Good evening fellow experts,
    I have got a button in my sheet that is adding a new row with two checkboxes. I want to automatically set to every new added row the conditional formating as can be seen in the code. The conditional fromating should set the different background colour in a cell once the checkbox is ticked (assigned cell has TRUE value) To get the code for conditional formating I recorded a macro so, that i setted the conditional formating on one cell and i changed the code then so, that it will be done for the whole row (I mean range with 14 cells in the same row). Despite that it is not working fine and when i tick the checkbox, nothing happens, the colour change itseld only when i push the button one more time. I want it to react immediately after ticking.

    HTML Code: 

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: conditional formating error in code

    No need to loop, though you said 14 and your code said 12 columns:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    07-13-2015
    Location
    Slovakia
    MS-Off Ver
    2007, 2010, 2013
    Posts
    76

    Re: conditional formating error in code

    many thanks, works amazing!

+ 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. VBA code for Conditional formating for more rows and columns and criteria
    By antoanand1981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2014, 12:17 AM
  2. [SOLVED] VB Code for Conditional Formating
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-25-2014, 09:50 AM
  3. [SOLVED] VB Code for Conditional Formating on Font
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2014, 11:41 AM
  4. [SOLVED] Conditional Formating Error Message
    By AVDPDHL in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-10-2014, 11:51 AM
  5. [SOLVED] Conditional Formating from Color Code Table
    By mycon73 in forum Excel General
    Replies: 16
    Last Post: 11-23-2013, 12:42 AM
  6. Conditional Formating to flag % Error
    By Grandinett in forum Excel General
    Replies: 5
    Last Post: 06-05-2012, 12:52 PM
  7. TextBox Conditional Formating code not working
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-23-2011, 08:42 PM

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