Highlight If Larger than Other Column

Google Sheets Conditional Formatting: Highlight Hours Worked Over Hours Paid The video shows how to use Google Sheets conditional formatting to highlight cells in column B (hours worked) when they are greater than the corresponding cells in column C (hours paid) so you can quickly spot overtime to bill. It demonstrates selecting the target range, opening Format → Conditional formatting, changing the rule to “Custom formula is,” and using a comparison formula like =B1 → C1. It explains adjusting the “Apply to range” (e.g., starting at B3 instead of B1) and updating the custom formula references accordingly (e.g., =B3 → C3) because the formula is tied to the selected range. It also shows changing the formatting style (background red and text white) for high-contrast alerts. 00:00 Goal Highlight Overtime 00:17 Open Conditional Formatting 00:40 Custom Formula Setup 01:11 Fix Range References 01:39 Choose Colors and Results 01:55 Channel Outro and Next Videos