+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting macro - apply to all rows

  1. #1
    Registered User
    Join Date
    06-22-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Conditional formatting macro - apply to all rows

    Hi All,

    I am trying to pull together a macro which will format the data I pull from our system to save me from doing it manually.

    It is almost at the point where I can run the macro and it will spit out exactly what I want. However, there's one step which is frustrating me slightly. The below macro is supposed to add a conditional formatting to a range of cells to highlight them Red, Orange or Green depending on their aging.

    At the moment this works, but I have to select a range to apply the formula to, and the number of the rows in the report is not static (it will be different every month). Is there any way that instead of inputting a range manually I can get the macro to apply the conditional formatting to the bottom of the data?

    I've highlighted the line in bold below which I think would need to be updated. Any help would be greatly appreciated.

    Thanks!


    ----------------------------------

    Please Login or Register  to view this content.
    Last edited by iwalke; 06-22-2015 at 07:15 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional formatting macro - apply to all rows

    Hi
    please add code tags as per forum rules - Thx

  3. #3
    Registered User
    Join Date
    06-22-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: Conditional formatting macro - apply to all rows

    Apologies, I have now updated my original post. Thanks

+ 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. Replies: 6
    Last Post: 02-18-2015, 03:40 AM
  2. [SOLVED] Apply conditional formatting to rows below
    By ibenegal in forum Excel General
    Replies: 3
    Last Post: 01-07-2015, 03:11 AM
  3. [SOLVED] Apply Conditional Formatting Settings to remaining rows
    By excelneub in forum Excel General
    Replies: 2
    Last Post: 08-27-2014, 09:06 AM
  4. Macro to apply colour conditional formatting to four columns
    By mayfaring in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 08:16 PM
  5. Macro to apply several conditional formatting criteria
    By useR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 12:05 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