Also, when copying the conditional format to the entire column, you could have selected just the cells that contained data before using the Paste Special command.

• 此外,将条件格式复制到整列中时,您可能只选择了其中包含使用“选择性粘贴”命令之前的数据的单元格。