Results 1 to 7 of 7

conditional formatting with formula problem

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2022
    Location
    Singapore
    MS-Off Ver
    2019
    Posts
    53

    conditional formatting with formula problem

    Hi Experts,

    This is a follow up from my previous thread https://www.excelforum.com/excel-gen...ml#post5776804 and I was doing some experiment with it to highlight the numbers in Number2 Column by using the formula =INDEX($D$2:$D$1000,MATCH($F2&G2,$B$2:$B$1000&$C$2:$C$1000,0))>0 in conditional formatting.

    Number1 Number2 Frequency
    2 60 1
    2 54 2
    2 34 2
    2 22 1
    2 32 1
    2 42 1
    2 40 3
    2 36 1
    2 48 1
    2 44 1
    2 28 1
    2 30 2
    2 24 1
    2 58 1
    2 26 2
    2 56 1
    2 52 2
    2 38 1
    2 46 1
    2 50 1

    But there's some error as boxed in red below which they shouldn't be highlighted. Pls advise if it's the equation in the conditional formatting which is wrong resulting in this happening and if yes, pls help to resolve this by providing the correct equation. Thanks.

    1.png
    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. conditional formatting formula problem
    By eugz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2022, 12:06 AM
  2. Conditional Formatting Using Formula Problem
    By sharpbriar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2020, 06:23 AM
  3. Conditional Formatting Formula Problem
    By Jango Fett in forum Excel General
    Replies: 4
    Last Post: 01-22-2019, 12:21 PM
  4. [SOLVED] Conditional Formatting formula problem
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2016, 08:41 AM
  5. [SOLVED] Conditional Formatting - Formula Problem?
    By KenMcN in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 03:00 PM
  6. [SOLVED] formula problem w/ conditional formatting
    By edwinculanding in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2013, 05:20 AM
  7. Conditional Formatting formula problem
    By ddub25 in forum Excel General
    Replies: 3
    Last Post: 01-21-2010, 08:24 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