Conditional Formatting in Excel Based on Another Cell

Conditional formatting is a useful tool in Excel with which you can better analyze your data visually. In this tutorial we will look at the predefined formatting options that Excel is providing us but in the example we will also learn how to use conditional formatting formulas to format cells based on another cell.
At the end, you will learn how to apply conditional formatting to highlight a row instead of only a cell.
Note that conditional formatting is basically like an IF function. So, if your defined formula returns true, then the selected cells will be formatted.

Timeline:
00:00 Introduction
00:24 Data Bars
01:19 Color Scales
01:47 Icon Sets
02:07 Predefined Mathematical Conditions (greater than; above average; ...)
03:12 Custom Formatting Based on Another Cell
05:31 Formatting Whole Row Based on Another Cell

[LeonRenner]

If you wanna spread some 💗 please destroy the 👍 button on that video, so I can make more videos like this in the future. Thank you! 💗💗