|
|
|
|
#1
12-04-2012, 12:35 AM
|
|||
|
|||
Hi uhlersa
Conditional formatting will achieve this. As per your sample data. Select the range of cells in column G (or the entire column) you wish to apply the formatting to. On the home tab > conditional formatting > new rule > use a formula to determine which cells to format. In the box Format values etc: =OR($G1=$J$1,$G1=$J$2,$G1=$J$3) Format text, fill etc to your requirements. Kevin 
|
|
|
|
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 32bit 
Office 2010 32bit
Hybrid Mode