+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting using a userform.

  1. #1
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Post Conditional Formatting using a userform.

    How would i conditional format with a user form.

    The idea is that i would have 3 colors Green, Yellow & Red, then a text box next to each of the colors. When you type say '60' into the text box next to Green, it highlights all colors greater or equal to 60, to green, in my range selected on excel.

    Here's an example of what i would like if green was set to 60, yellow was set to 30 and red was set to 0:

    1.png

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Conditional Formatting using a userform.

    Some of us can't even see PNG files. In any event, it would be a lot better if you could post a sample workbook.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. [SOLVED] Conditional formatting from userform
    By bulina2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2016, 10:14 AM
  2. Replies: 0
    Last Post: 02-04-2015, 10:12 AM
  3. [SOLVED] Conditional Formatting of the Textbox in a Userform - Can this be done?
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2014, 12:17 PM
  4. Conditional formatting within a userform
    By FennersKnows in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2012, 04:12 AM
  5. Conditional Formatting on a UserForm?
    By kirsty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2011, 06:02 PM
  6. Conditional formatting cells threw a userform
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2010, 10:20 AM
  7. Conditional formatting of a userform in VBA
    By ilovelagar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2009, 10:01 AM

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