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?
#If formulas using dates openoffice conditional formatting how to
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.