Results 1 to 11 of 11

Excel 2007 : Highlight percentage pairs..RE..Highlight matching pairs

Threaded View

  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    40

    Highlight percentage pairs..RE..Highlight matching pairs

    Further to "Highlight matching pairs" ( works as wanted...thanks).

    I now need to use conditional format to find highlighted "matching pairs" that show a percentage greater than 49% and put a border around them ( or any way of showing other than bold font or colour font)...explained better in the attached worksheet.

    Doesn't matter if it's an addition to the conditional format formula already used or a totally new conditional format as long as the original highlighting still works.

    Sorry if I'm making a "pigs ear" out of the explanation but the worksheet explains better.

    Thanks in advance.
    Last edited by Rob44; 01-05-2011 at 09:36 PM.

Thread Information

Users Browsing this Thread

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

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