Instruction: Explain the process to apply multiple conditional formatting rules to highlight data trends and outliers in a dataset.
Context: This question tests the candidate's understanding of Excel's conditional formatting features beyond basic color-coding, focusing on advanced rule creation.