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.
|