Excel Conditional Formatting with Formula | Highlight Rows based on a cell value

Highlight rows based on a cell value in Excel, using conditional formatting with a formula. 📥 Download the practice file: https://www.xelplus.com/excel-conditional-formatting-rows/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-conditional-formatting&utm_content=cf-highlight-rows#download 🎓 500,000+ enrolled in our courses. Learn the formulas and features you use every day with Excel Essentials 👉 https://www.xelplus.com/course/learn-excel-essentials/?utm_source=yt-video&utm_medium=vid-general&utm_campaign=essentials&utm_content=cf-highlight-rows The formula in a conditional formatting rule is always written for the first cell of your range. That's where most rules go wrong. Get the dollar signs wrong and the rule highlights nothing, or everything. The fix is to test your formula on the grid first (a great trick from Mike Girvin). For single values, remove the dollar signs from the cell you check. For full rows, lock the column with $ so every cell in the row looks at the same value. You'll also see why copied cells bring their rules with them, and how to paste without them. Good to know: In Microsoft 365, Ctrl+Shift+V pastes values only. That leaves conditional formatting rules behind, but number formats too. 00:00 Highlight rows based on a cell value in Excel 00:31 The example: highlight salaries above a threshold 01:03 New rule: use a formula to determine which cells to format 01:48 Key rule: write the formula for the first cell 02:53 Why it highlights nothing (or everything) 03:34 The grid trick to test your formula 04:28 Update the rule with Manage Rules 05:35 Highlight entire rows 06:52 Lock the column with $ so it works for every row 07:48 Copied cells bring their rules (Clear Rules) 08:13 Paste without conditional formatting (Paste Special) 08:49 Recap: if a rule fails, test it on the grid 🎬 Advanced Excel tips and tricks playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani #excel #exceltips #conditionalformatting