+ Reply to Thread
Results 1 to 3 of 3

I need to adjust this working macro to cover a few scenarios

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    new hampshire
    MS-Off Ver
    Excel 2010
    Posts
    37

    I need to adjust this working macro to cover a few scenarios

    I have a few buttons on my page that I would like to change colors depending on the value in cell AI1. Right now this is the code I have:

    Please Login or Register  to view this content.
    What I would like is to add formatting for "rounded rectangle 4" as well. if the cell = 1, number 4 changes color, if the cell = 2 both change color, and if the cell =3 then only 5 changes color.

    Thank you in advance.
    Last edited by mk3ll00; 05-23-2014 at 09:28 AM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: I need to adjust this working macro to cover a few scenarios

    Hi,

    I don't know if the following does what you want, but I think it does what you asked for (tested and working using Excel 2003):
    Please Login or Register  to view this content.
    Lewis

  3. #3
    Registered User
    Join Date
    03-19-2013
    Location
    new hampshire
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: I need to adjust this working macro to cover a few scenarios

    It works perfectly! Thank you for the help Lewis!

+ 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. How to adjust a formula to look at persons working multiple shifts.
    By DyneD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2013, 12:52 PM
  2. [SOLVED] Networkadys formula is not working in some scenarios - please help!
    By chauhan101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2012, 11:23 AM
  3. Macro to Run several valuation Scenarios
    By cross1581 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2012, 05:01 PM
  4. Word Cloud (Working but want to tweak to adjust font color based on frequency and...)
    By VTHokie11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2011, 03:23 PM
  5. [SOLVED] how do I adjust working calendar (6 day work week) in excel that .
    By Hatem in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2005, 08:06 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