This 46th video is about Excel conditional formatting based on another cell.
There 3 parts:
1. Apply to the range: select the range to be formatted
2. Rule type: select the type of rule that we will use, select the type of formula
3. Format with: select the type of format to be used
There are 3 types of rules that I give in this video.
Conditional formatting in excel is to give a special format to a cell. For example: if a cell has a number of 2, then the other cells will have a different effect too. Excel conditional formatting can also use a formula.
Download the file;
https://docs.google.com/spreadsheets/...
#rumusexcel #belajarexcel #excelvideotutorial