RULE PRECEDENCE IN CONDITIONAL FORMATTING Conditional Formatting in Excel makes tasks easier and more user-friendly but it can sometimes be…