Conditional Formatting using a formula, match/index

A

Anthon

19 MARCan the following be done? Match
Column B, find the same names, colour the cell in a certain colour, find the
next match and make it a different colour etc etc. The column needs to remain
in the same order as below.

Thanks
Anthon

A B
1 JOHN
2 TIM
3 JOHN
4 ANDY
5 JILL
6 JEREMY
7 TIM
8 KEITH
9 MARK
10 ANDY
11 ROBERT
12 JILL
13 MARK
14 JIM
15 ROBERT
16 KEITH
17 KIM
18 DANK
20 KEITH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formats, match or index 14
Index and Match 5
INDEX MATCH SMALL 13
Index / Match Formula Problem 4
Conditional Formatting 0
Conditional Formatting on Index,Match formula 3
Conditional Formatting VBA with formula to find string 3
Index/Match Lookup with a merged col 2

Top