+ Reply to Thread
Results 1 to 4 of 4

Colourcode based on value range

  1. #1
    Registered User
    Join Date
    07-06-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    3

    Colourcode based on value range

    I need to coulorcode in red all values in a worksheet that are outside a range. The range (for example between 0 and 100) will need to be typed into manually as can vary. For example, in a worksheet I want to have all values smaller than 0 and larger than 1000 in red. In the next worksheet, I want all values smaller than 0 and bigger than 500 in red.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Colourcode based on value range

    Hello cocohead,

    Welcome to the Forum!

    This macro will prompt you for both the lower and upper limits. You can run this macro on any sheet in your workbook.
    Please Login or Register  to view this content.

    Adding the Macro (Excel 95 - 2003)
    1. Copy the macro above pressing the keys CTRL+C
    2. Open your workbook
    3. Press the keys ALT+F11 to open the Visual Basic Editor
    4. Press the keys ALT+I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Paste the code by pressing the keys CTRL+V
    7. Make any custom changes to the macro if needed at this time.
    8. Save the Macro by pressing the keys CTRL+S
    9. Press the keys ALT+Q to exit the Editor, and return to Excel.

    To Run the Macro...
    To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-06-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Colourcode based on value range

    thanks that works. How do I exclude columns A and B. Dont want to colourcode columns A and B

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Colourcode based on value range

    Hello cocohead,

    This version of the macro will exclude all cells in columns "A:B" from being coloured.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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