“Format Only Cells that Contain” is an option under Conditional formatting.Ĭonditional formatting is a technique or rather we can say it is a feature which allows the user to apply customizable format based on specific criteria, in simple words we can say that it highlights particular cell and text with different colors, it is more or like giving a condition.įor example: on specifying the rule “If the selected range is equal to 1(one) apply the format” this rule changes the cell to a specified format wherever it finds 1(one) in a range.
