You are a very risky intergalactic bounty hunter, and you're looking for your next target. You do know your highest value target, but you wanna know what targets are the most dangerous, but also the highest bounty. I would like to see just a list of yes or no, yes or no. If they're a high danger and a high. Bounty or a high bounty, either one. So I'm gonna go over here and say, is this a go? Am I gonna go after these particular ones? We can do equals, and I'm gonna say if, and I'm gonna have a logical expression here that's either gonna be true or false. And then I'm gonna say, if that's true, then it's a go. And if it's false. I'm gonna say, hold off here. We want the operator or, and so inside of, or we're gonna have two things.

C five is greater than seven, meaning eight, nine, or 10. And then we're gonna do another comma, and we're gonna say the bounty is greater than 100,000. Interna. Intergalactic. Credits and it's going to now tell me is it a go or is it hold off all the way down. But I wanna make it very clear. So anytime it's a go, let's highlight it all green, go up to format conditional formatting . I'm going to end up applying this to a colon e the entire row . I'm going to go to custom formula is , and I'm gonna say equals E one equals go. And you see only a few are highlighted and it's not the entire row yet. I need to do one special thing, which is add a dollar sign in front

of that E and now the entire row is. Green actually all of this range here. So if you see over to the right over f and g or not, but that whole range is highlighted and it's all looking at column E and saying, is this target a go or not? Is it hold off or go? Now I have the best riskiest targets for my intergalactic bounty hunter business. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos.

But for right now, right here, one of these videos is gonna be your next Google sheet.