Find High Value Targets in Google Sheets

Google Sheets IF + OR Formula and Conditional Formatting to Flag “Go” Targets This episode shows how to use an IF formula combined with the OR operator in Google Sheets to label each row as “go” or “hold off” based on whether a danger rating in C is greater than 7 or a bounty value is greater than 100,000 credits. It then demonstrates applying conditional formatting to highlight entire rows when the result in column E equals “go,” including how to use a custom formula and add a dollar sign to lock the column reference (e.g., $E) so the formatting checks column E across the whole selected range. 00:00 Bounty Hunter Setup 00:35 IF OR Decision Formula 00:56 Danger and Bounty Thresholds 01:33 Conditional Formatting Highlights 02:07 Absolute Reference Trick 02:41 Wrap Up and Subscribe