Instead of Sheet1!$D$6 in the IF-part of the formula you can of course refer to another cell, for instance Sheet1!E1 and then enter the criteria (7 Habits S1 or something else) in this cell. After editing remember to hold down Ctrl and Shift before pressing Enter.