9-25
- 2(ERROR) ... Inputs “ERROR” into the conditional expression. For example, you can use
this to input A1=ERROR. Decision depends on whether or not “ERROR” is displayed in the
cell being referenced in the conditional expression (A1 in the example here).
- 3(BLANK) ... Inputs “BLANK” into the conditional expression. Decision depends on
whether or not the cell being referenced in the conditional expression is blank.
- 4(And) ... Inputs the logical operator “And” into the conditional expression.
- 5(Or) ... Inputs the logical operator “Or” into the conditional expression.
Note
• You can input up to 255 bytes of data for a conditional expression.
• ERROR, BLANK, and text strings can be used in a conditional expression only in the
syntaxes shown below or their inverses (ERROR=<Cell>, etc.). <Cell> stands for a single cell
reference (such as A1).
<Cell>=ERROR, <Cell>=BLANK, <Cell>≠ERROR, <Cell>≠BLANK, <Cell>=<text string>,
<Cell>≠<text string>
u To delete conditional formatting settings
1. Select the cell or range of cells whose conditional formatting you want to delete.
• Performing step 2 below will immediately clear, without any confirmation message, both
the conditional formatting as well as any character color, area color, and paint style
settings configured for the selected cell(s).
2. Press 5(CLEAR)2(FORMAT).
k Conditional Formatting Setting Example
In this example we will show how to configure the range of cells B3:C4 with the conditional
formatting shown below. This procedure assumes that the cells already contain values.
Condition
When the value input in
the cell (=C) satisfies this
condition:
This formatting is applied:
Character
Color
Area Color Paint Style
1 C<0 Red Yellow Normal
2
0≤C≤100
Blue Magenta Lighter
To Next Page
Loading...
Need help?
General
