 Alright, this question comes from one of my favorite Excel colleagues. She sent me this sheet that has checkboxes in E, G, I, and K that switch the question from true or false. And she wants these three cells to be formatted in different colors depending on the selections. So let's get started. She wants these to be highlighted green when E2 is true. So from the conditional formatting, do rule. Here use a formula to determine which cells to format, and this one's gonna be real easy. It's just when E2 is true, so equals, and we'll click on E2 there, and that's it. Because this is true or false as it is, it's gonna return a false and nothing will happen if it returns a true. We're gonna switch the formatting here to be green, okay? And okay, and here, sure enough, those are now green. Next question, yellow, when E2 and G2 are true. And so from the conditional formatting, new rule, again formula to determine. And for this one, we'll type equals, and she wants it to be and. So E2 and G2, so we'll type and. Here's our E2 comma G2. So this one has to be a true and a true to return a true. If that is all true, we'll have that be yellow, okay, okay? So here that's green, that's yellow, great if I unclick this, it's nothing, perfect. Last one, and this one is tricky for two reasons. One, it's and, and and for. And the other one has something to do with precedence, so I'll talk about that in a second. So here, I'm the conditional formatting, new rule, use a formula. And this formula is going to be equal to the and of E2. Because that one has to be true, comma, or one of these two. I, two, or K2 has to be true, parentheses, parentheses. And so if I2 is true, or K2 is true, or bolted true, that'll return a true. And then if E2 is true, then all together, that'll be a true, and we want that to be blue. Let's do that. Okay, okay. So now that gives us green, that gives us yellow, great, come back to green. Click this, that's blue, fantastic. This is blue, fantastic, both of those is blue, great. And now G2 is supposed to trump everything. If I click this, it stays blue and we actually wanted that to come back to yellow. And the reason it isn't working is if we come to manage rules, all we have to do is take this rule and move it down one. If you notice, parenthetically, they tell you that the rules are applied in the order shown. By moving it down one, it'll now do what she wanted. So if G is on, if E and G are on, it's yellow, no matter what, regardless of what I and K are doing. But if G is off, then it'll test this I and K. And we come back to green, and that was all of the cases. Enjoy.