Excel Conditional Formatting Based on Another Cell

Опубликовано: 04 Октябрь 2024
на канале: Excel Tutorial
50
1

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