Forum Discussion
Formula Help
In the conditional formatting you just need the ORDER of the rules to be correct. In the below image you can see the cell is green even though both conditions are true. IF I reverse the order then it will stay red. To move the order there are up down arrows to the right of the "Duplicate Rule" button. Note you can also use the 'Stop if True' checkbox to the right of the rule. So in this example, in addition to making the background red it also makes the text YELLOW and BOLD, which is still happening but if the 'Stop if True' checkbox is clicked then that additional formatting will not happen.
In the conditional formatting you just need the ORDER of the rules to be correct. In the below image you can see the cell is green even though both conditions are true. IF I reverse the order then it will stay red. To move the order there are up down arrows to the right of the "Duplicate Rule" button. Note you can also use the 'Stop if True' checkbox to the right of the rule. So in this example, in addition to making the background red it also makes the text YELLOW and BOLD, which is still happening but if the 'Stop if True' checkbox is clicked then that additional formatting will not happen.
Thank you! I wish I had thought to try that. It was such a simple solution. I appreciate it.