In Excel, the common reason for getting This action won't work on multiple selections error is because of a bad selection. Here's how to fix it.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...