outlook conditional formatting on certain text values

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.

Outlook conditional formatting on certain text values