Not containing is opposite to containing. For example, the condition “If cell contains Praveen” “Apply this format” This condition applies the format to the cells containing Praveen. This condition formats the cell if the selected range contains a specified value. According to the specific text: There are totally 4 conditions available shown in fig 1.3 Figure 1.4 Containing & not containing Let’s take the above example but keeping the condition as less than equal to, this condition formats the cells in the selected range if it contains less than 12(11,10,9,…….) and 12. Less than equal to is opposite to Greater than equal to. For example, the condition “If cell contains a value greater than and equal to 12” “Apply this format” This condition applies the format to the cells if it contains more than 12(13,14,15,…….) and 12. This condition formats the cell if the selected range is greater than and equal to the specified number. Greater than equal to & less than equal to: Less than is opposite to Greater than let’s take the above example but keeping the condition as less than, this condition formats the cells in the selected range if it contains less than 12. For example, the condition “If cell contains a value greater than 12” “Apply this format” This condition applies the format to the cells if it contains more than 12.
This condition formats the cell if the selected range is greater than the specified number. Let’s take the above example but keeping the condition as not equal to, this condition formats the cells in the range which doesn’t contain Praveen. For example, The condition “if cell is equal to Praveen” “Apply this format” this condition applies the format wherever it finds Praveen in the selected range.
This condition formats if the cell is equal to the specified condition. This condition applies the format the cells which contain values 1,2,3,4,5. This condition formats the cell if the selected range has the specified “between” values.įor example, the condition “if cell contains the values between 1 to 5” “Apply this format”. According to the cell value: There are totally 4 conditions available shown in fig 1.2 Figure 1.2 Between & Not between: The condition which you specify changes according to the value that cell contains, explained below in detail. according to content (text, numeric, dates as shown in figure 1.1) and applies the condition to the cell. In Excel, Conditional Formatting > New rule > Format only cells that contain, is a formatting option that applies a specific format based on the contents in a cell i.e. What does the feature”format only cells that contain” do in Excel?
In this article we are going to see about how to use New rules > Format Only cells that contain. Under Conditional Formatting there are many options as shown in the figure 1, here, we are going to focus on new rules. This feature is available since 2007 in Excel.Yes, we can also manually format each but think if you have a 1000 line items in your excel sheet it becomes difficult to explore and analyze data’s, catch critical issue or to find out the trends or patterns, here conditional formatting plays a major role by highlighting cells through different colors or giving importance to unusual values and picturise the data by making use of data bars, color scales and icon sets that amounts to specific variations in the data.Ĭonditional formatting mainly works keeping the “If” statement as the base like “If the condition is true” “then apply the format to the cell”. “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.