Even Though I Specified to only Highlight Rows that Column Q has "Not Paid" it highlight on row with PAID Items and not the other Rows that have Not Paid! Any Ideas?
With what you provided I’d probably check the cell reference used in the conditional formatting rule. It might have been a typo where it is off by one row.
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! 😁
Question on Conditional Formating, I have used it for many years... but I seem to have an Issue maybe you can help with it?
Even Though I Specified to only Highlight Rows that Column Q has "Not Paid" it highlight on row with PAID Items and not the other Rows that have Not Paid! Any Ideas?
With what you provided I’d probably check the cell reference used in the conditional formatting rule. It might have been a typo where it is off by one row.
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.