To change a filter condition, in the Filters area of Advanced Filter, select the condition, then choose Edit. Modify the condition by changing the values in Filter By, Condition, or Value. Select Change Condition, then select Change Filter, and choose OK, as shown in Figure 5‑15.

To delete a filter condition, in the Filters area of Advanced Filter, select the Filter and select Delete. Then, select the Condition and select Delete. Choose OK. Verify that any remaining filter conditions display the expected results.