View Single Post
 
Old 06-18-2018, 03:42 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

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.
Reply With Quote