+ Reply to Thread
Results 1 to 2 of 2

Macro to set up conditional message based on results of conditional formatting

  1. #1
    Registered User
    Join Date
    04-25-2016
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    1

    Macro to set up conditional message based on results of conditional formatting

    Hi there,

    I have a macro that checks for duplicates in employee ID in column A and changes the cell color and text color for any duplicate values. I am looking to have a message box pop up after this macro has run that says either "No Duplicates found" or "Duplicates Found - Please Review" based on the results of the conditional formatting.

    Any insight on this is appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Macro to set up conditional message based on results of conditional formatting

    Try this code

    Please Login or Register  to view this content.
    next time instead of attaching file with only the code you can just post the code directly into the forum

    ps this code leaves you with a new conditional format every time you run it
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 3
    Last Post: 02-16-2016, 06:40 AM
  2. Conditional Formatting Columns Based On Row Results
    By Kabukibear in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2015, 06:35 AM
  3. Conditional formatting based on other results from other sheets......
    By Samba Glee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2013, 02:20 PM
  4. Replies: 2
    Last Post: 10-16-2012, 04:20 PM
  5. Conditional formatting based on two cell results
    By Molecheese in forum Excel General
    Replies: 2
    Last Post: 05-07-2009, 04:23 AM
  6. Pop-up message box macro after conditional formatting?
    By p3te2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2008, 07:39 AM
  7. [SOLVED] CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL
    By jpreman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2006, 11:10 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