Excel 2007 : 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.

If you're willing to accept a hidden helper column (L), then this might work for you.

Cheers,

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

Normally this thread would be closed but given reply etc and slight variation in file we will merge the two threads.

Also, for those not aware - the reason for the embedded INDEX in the first sample file is detailed on Rob44's first thread (a bug specific to XL2007)

Based on your posts/sample files I would suggest highlighting D1:E30 and applying the following rule:

Please Login or Register  to view this content.

the ISNUMBER test in the original in superfluous - and to reiterate the embedded INDEX is a necessity in XL2007.

DonkeyOte.....my apologies I didn't realise there was a rule about duplicate posts.
I thought that I hadn't explained very well the first time ...so did it again.

Thanks for your formula, worked well, didn't understand it but it worked.

New problem.....
I can't seem to get my head around how to tie the 50% search with matching single items.
I have to compare two columns and highlight items which show as greater than 50%.
This is a search for single items this time but I still can't get anything to work for me.

Have attached a new worksheet which should explain better.

Any help would be greatly appreciated.

Originally Posted by Rob44

I have to compare two columns and highlight items which show as greater than 50%.

It would just be a variant of the prior test (ie without the first concatenated item)

Please Login or Register  to view this content.

If you are running the above in conjunction with the other tests outlined then this test should test be conducted after those (in terms of ordering)

Originally Posted by Rob44

Thanks for your formula, worked well, didn't understand it but it worked.

The criteria string reflects the concatenation of the literal terms in D & E along with a Boolean TRUE
This criteria is compared to a listing of the literal terms in H & I concatenated along with a Boolean for each item where the Boolean itself is determined by whether or not associated value in J >= 50%

The below is not really relevant to the thread and (going forward) queries of this nature should be taken up via PM with an appropriate Moderator/Admin but ...

Originally Posted by Rob44

Can I query my warning for duplicate posting.

Originally Posted by Rules

Rule 5....
5. Don't duplicate posts. We have seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one.

Rule 5 only refers to duplicate posting in different forums and not in a forum. I don't believe I was in breach of the rule.

The note regards the various forums is there specifically to notify users that posting the same question in two separate forums is still considered to be duplication.

In fairness to the rules as they are - they have been in place for some time and rarely generate confusion

Originally Posted by Rob44

5. Don't duplicate posts.

Covers everything I think

I would argue the above is too vague - spec. regards posting questions across different forums within the same message board - granted this is debatable

Originally Posted by Rob44

As I said before I didn't think I had explained the problem very well and re-wrote it. Hence the second post but within the same forum.

Going forward, if you need to clarify a point in a thread do so by replying to it with the clarifications / latest attachment.