What will happen if there are 2 conditional formatting in a row? like for example, the priority is High but it the status is Completed. Which conditional formatting will it follow?
Great question! Conditional Formatting rules can be applied in a certain order. In this example, the rule that checks for Completed tasks happens first and so it applies the Conditional Formatting first, even though the Priority is High. If we reversed the order of the rules so that the check for High Priority tasks happens first, then the High Priority Completed tasks would have been highlighted yellow with bolded red text.
Amazing video!
Thanks Brad! 😁
What will happen if there are 2 conditional formatting in a row? like for example, the priority is High but it the status is Completed. Which conditional formatting will it follow?
Great question! Conditional Formatting rules can be applied in a certain order. In this example, the rule that checks for Completed tasks happens first and so it applies the Conditional Formatting first, even though the Priority is High. If we reversed the order of the rules so that the check for High Priority tasks happens first, then the High Priority Completed tasks would have been highlighted yellow with bolded red text.