+ Reply to Thread
Results 1 to 1 of 1

Userform Listbox use of ColorIndex or ColorInterior like Conditional Formatting

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Manitoba
    MS-Off Ver
    2016
    Posts
    36

    Userform Listbox use of ColorIndex or ColorInterior like Conditional Formatting

    Hello,

    With recent help from some great people on the forum I thought I would check if anyone knows of a way to have a Listbox show a similar way to that of conditional formatting between 2 columns.
    Right now I have 2 columns that if Column G has a different value to Column F then color cell red
    example:
    F2 = 1 and G2=9 (no color-this is equal)
    F3= 1 and G3=5 or 0 (color Red)
    F4= 1 and G4= 1(no color this is equal)
    F5=5 and G5= 5 (no color this is equal)
    F6=5 and G6= 1 or 9 or 0 (color Red)
    F7=0 and G7=0 (no color this is equal)
    F8=0 and G8=1 or 9 or 5 (color Red)
    It's easy using conditional formatting but I would like the same results showing in my listbox on a userform.
    Is this possible?
    I heard it may be possible with Listview instead of a Listbox but I have no idea what code is required using VBA
    Any suggestions?

    I can supply the workbook if required as it is a tester file that I had great help getting specific columns to not have duplicates and I wanted to continue working on this project and this is the next step in my learning and development but need assistance and or recommendations.

    thanks
    Last edited by bbqqsmokeman; 08-23-2017 at 09:58 PM.

+ 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. Userform listbox formatting on the fields of date
    By carlrubber in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2017, 11:06 AM
  2. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  3. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  4. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  5. Userform Listbox Conditional on Previous Selection
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2011, 10:08 AM
  6. interior.colorindex used with conditional formatting
    By Wazooli in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-24-2005, 09:06 PM
  7. [SOLVED] conditional formatting and interior.colorindex
    By Wazooli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2005, 02:06 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