|
|
#2
06-18-2018, 03:42 AM
|
||||
|
||||
You should specify a row number which is the same as the first cell in your selection when applying the CF. For example:
=AND($C2=[PRICE],$D2="[WORDS]") Note that there is no $ in front of the row number, so it adjusts for each row to which the CF is applied. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 NEED: Formula for referencing data in two files
|
ross.lowe | Excel | 1 | 02-21-2017 09:34 AM |
|
Create formula for entire column
|
tdodson | Excel | 2 | 10-27-2015 09:38 PM |
| Naming Cells for formula referencing | lynchbro | Excel | 6 | 06-26-2014 07:45 AM |
| Referencing a value over 255 characters within a table PLUS strange formula behaviour | TishyMouse | Excel | 2 | 01-08-2013 09:39 AM |
| Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode