|
|
|
|
#1
12-04-2012, 12:27 AM
|
||||
|
||||
Select col G starting at G2 - Go to conditional formatting - Insert following formula as condition Code:
=countif($J$2:$J$50,$G2) Adapt the J range to your needs
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post Last edited by Pecoflyer; 12-04-2012 at 01:07 AM. Reason: add code tags 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
 Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
|
match formatting help
|
Lynnwork | Excel | 1 | 12-02-2011 08:39 AM |
|
Vlookup, offset, match & countif
|
jujuwillis | Excel | 2 | 10-15-2011 11:06 AM |
|
Vlookup and If conditions together along with match formulas
|
david_benjamin | Excel | 2 | 04-11-2011 11:30 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode