+ Reply to Thread
Results 1 to 3 of 3

Add conditional formatting layers to existing functional macro

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013 Office 365
    Posts
    9

    Add conditional formatting layers to existing functional macro

    Can someone help me add conditional formatting layers to this macro. My intent is to keep /maintain the same range, but add color to the pivot table to based on a different formula that would include over posted speed limit ranges. I just don't know where to begin the 'with' statements or if I have to add 'If' statement for each layer of conditional formatting.

    0-9 MPH
    =AND($H5>MIN(1,8),$H5<MAX(9))

    10-14 MPH
    =AND($H5>MIN(10),$H5<MAX(14))

    15-19 MPH
    =AND($H5>MIN(15),$H5<MAX(19))

    20+ MPH
    =AND($H5>MAX(20))


    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 03-18-2020 at 11:41 AM. Reason: Replaced HTML with code tags
    --
    Keith Bell
    [email protected]

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Add conditional formatting layers to existing functional macro

    Change the .Font and\or .Interior.Color of each condition to suit.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    07-15-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013 Office 365
    Posts
    9

    Re: Add conditional formatting layers to existing functional macro

    AlphaFrog--good morning,

    Thank you for your help--the code works. I appreciate your expertise.

+ 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. Conditional Formatting for existing Formula
    By whitt3rx in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-09-2019, 12:51 AM
  2. Conditional Formatting, while ignoring existing formatting
    By weltallica in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2016, 06:46 AM
  3. Replies: 3
    Last Post: 06-11-2015, 03:54 PM
  4. Can i use OR functional for conditional formatting in a drop down list
    By manna1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2013, 04:58 PM
  5. Replies: 0
    Last Post: 03-28-2013, 02:35 PM
  6. conditional Formatting based on existing formatting
    By jomili in forum Excel General
    Replies: 18
    Last Post: 02-18-2011, 10:17 AM
  7. [SOLVED] Conditional Formatting should not be limited to 3 layers.
    By Peyton in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 09:50 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1