+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting issues

  1. #1
    Forum Contributor
    Join Date
    12-06-2015
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    513

    Conditional formatting issues

    Dear all

    I have no idea why but the conditional formatting is in error

    I have used the=match formular to include a series of condition but one of the cell was unexpected hightlighted
    B49

    See attached

    Appreciate if you could hlep
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Conditional formatting issues

    You have two conditional formatting rule.

    please delete one ->>> select the conditional formatting data then press ->>> Alt->>O->>>D now delete which one you don't need.

    Hope this will help you
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Conditional formatting issues

    You match with "F33" to "F38" & second condition match with "A5"
    Why need "A5" where as you already matching with "F33:F38"
    Delect cf "A5" rules.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. Conditional Formatting issues
    By mattthorpe23 in forum Excel General
    Replies: 1
    Last Post: 09-29-2016, 07:07 AM
  2. Conditional Formatting Issues
    By jcolesRA725 in forum Excel General
    Replies: 2
    Last Post: 08-08-2016, 12:45 PM
  3. [SOLVED] Need Help: Conditional Formatting Issues
    By Jung Bin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2015, 04:52 AM
  4. [SOLVED] Conditional formatting issues
    By missydanni in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2015, 09:44 AM
  5. Having Issues with Conditional Formatting...
    By tatumrae in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2014, 06:30 PM
  6. Conditional Formatting Issues
    By smarch001 in forum Excel General
    Replies: 2
    Last Post: 02-22-2010, 10:10 PM
  7. Conditional Formatting Issues
    By merlot in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 11:05 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