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
Watch video Conditional Formatting in Excel Based on Another Cell online without registration, duration hours minute second in high quality. This video was added by user Leon Renner 14 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,883 once and liked it 19 people.