Results 1 to 6 of 6

Conditional Highlighting Rule Help

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2015
    Location
    North Carolina, USA
    MS-Off Ver
    2007
    Posts
    22

    Conditional Highlighting Rule Help

    I have a table showing aging invoices - some which have been partially paid and others which have not been paid at all. I have been trying to use "Conditional Formatting - Duplicate Values", to quickly identify which invoices have been partially paid vs invoices without any payment applied. But using the "Conditional Formatting - Duplicate Values" just highlights every instance within the entire table that has a duplicate value somewhere else in the table. I ONLY want to highlight rows for which the invoiced "Amount" is the same as the "Open Balance" for that invoice.

    Attached is worksheet with: 1. a sample of the table with NO conditional formatting applied, 2. a sample table showing the end result I'm trying to accomplish, and 3. a sample table with my wrong "Conditional Formatting - Duplicate Values" rule

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 02-15-2018, 11:54 PM
  2. Conditional Formatting Rule if x is y and
    By nwpassage in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2015, 12:18 PM
  3. Replies: 3
    Last Post: 12-13-2014, 05:11 PM
  4. Highlighting cells rule issue
    By xrajncajnx in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-07-2014, 12:38 PM
  5. Exception rule for highlighting cells macro
    By slavicgrip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2013, 01:33 AM
  6. [SOLVED] Conditional Rule to highlight
    By Jiptastic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2013, 01:03 PM
  7. conditional rule
    By durga_ikon in forum Excel General
    Replies: 2
    Last Post: 03-29-2013, 02:57 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