Conditional Formatting in Excel is a great way to improve the readability of reports. You can focus the reader’s eye on the important points and create an interactive element to your Excel data.
In this tutorial I’ll show you how you can use Excel conditional formatting to highlight rows based on another cell’s value. For example, you can use conditional formatting to highlight
values that are greater, equal, or less than the value in another cell.
I’ll also show you how you can properly use Excel conditional formatting with a formula. It can be tricky to get it right. If used incorrectly your conditional formatting will not work. To make sure you can successfully use formulas in Excel conditional formatting, I will share an Excel trick you can use to get it right every time.
00:00 Excel Conditional Formatting with Formula – the logic
03:12 Excel Trick for Conditional Formatting with Formula
04:42 Excel Conditional Formatting based on another cell
05:35 Excel Conditionally Formatting Entire Rows
07:45 How to Copy a Range With Conditional Formatting in Excel
⯆ DOWNLOAD the workbook here (scroll to the bottom of the post): https://www.xelplus.com/excel-conditional-formatting-rows
Playlist dedicated to advanced Excel tips & tricks: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!