◇太字・フォントサイズ・％・小数点・カンマ・通貨記号
Please choose a macro name (No symbols, spaces, or leading numbers allowed)
左上セル※２必須
(右下セル)※３表のとき
Select Range Option
Cell to determine the last row (e.g., A1)
No Condition (Default) ―Numbers― Cell value equals the number below Cell value does not equal the number below Cell value is less than the number below Cell value is greater than the number below Cell value is less than or equal to the number below Cell value is greater than or equal to the number below Cell value is between the two numbers (separated by a comma) Cell value is greater than or equal to the left number and less than the right number (separated by a comma) Cell value is greater than the left number and less than or equal to the right number (separated by a comma) Cell value is greater than the left number and less than the right number (separated by a comma) ―Strings― Cell value equals the string below Cell value does not equal the string below Cell value contains the string below Cell value does not contain the string below Cell value starts with the string below Cell value does not start with the string below Cell value ends with the string below Cell value does not end with the string below ―Cell Value Comparison― Cell value equals the value of the cell above Cell value does not equal the value of the cell above Cell value equals the value of the cell to the left Cell value does not equal the value of the cell to the left Cell value equals the value of the cell offset by the number below Cell value does not equal the value of the cell offset by the number below ―Blanks― Cell value is blank Cell value is not blank ―Formatting― Cell color is yellow RGB(255,255,0) Cell color is not yellow RGB(255,255,0) Cell value is bold Cell value is a date Bottom border of the cell is medium thick ―Formulas― Cell displays an error Cell value is TRUE Cell value is FALSE Custom condition using the variable ‘Cell’
※Numbers and strings are distinguished
Condition
Use the value of the cell in the upper field (e.g., A1)
Sequentially substitute the values from the cell in the upper field (e.g., A1) to the last row into the above condition
◆Change the Cell Position to Process - OffsetAs is0,0 One down1,0 One up-1,0 One right0,1 One left0,-1
◆Change the Cell Range to Process - ResizeExpand by 2 rows2 2 columns,2 2 rows and 2 columns2,2
処理の対象に、☑をいれてください
太字/取消太字にする 太字を取り消す
ﾌｫﾝﾄｻｲｽﾞ指定(例：16)※４
小数点以下の桁数0 1 2 3 4 5 6
％表示での小数点以下の桁数0 1 2 3 4
Disclaimer: We accept no responsibility for any damage or loss caused by the use of this app.
