Highlight cells with IF and Conditional formatting
#Excel #conditionalformatting #exceltipsandtricks #karpagamexcel
In this video, you will learn how to highlight cells in 2 different ways.
1. IF Condition :
IF condition is one of the most powerful function in excel. IF function is so popular because of its logical test ability ability. It allows the user to perform greater than, lesser than, equal to, not equal to and so on...
In this video, We want to find out when the sales of the hypermarket falls below 700, it should get get restock in the respective cells and if it is greater than 700, it should do nothing.
The formula is
=if(criteria _a is less than criteria_b,"Restock", " ")
This looks for the criteria, if it is met , it will bring restock in the respective cells.
On this , conditional formatting shall be applied. Go to conditional formatting, navigate through new rules and type the criteria
=b2:b12 = "restock"
click on format , choose the color, click on apply and OK from the same tab.
2. Conditional Fomatting
Select the range b2:b12,click on conditional formatting,choose new rule and type the logical test of IF function,
=b2 less than g2
click on format in the same dialog box, choose color, apply and click ok.
When the condition is met, the cells will be highlighted.