{"id":23099,"date":"2026-09-10T08:45:47","date_gmt":"2026-09-09T23:45:47","guid":{"rendered":"https:\/\/cg-method.com\/google\/google-sheets-conditional-formatting-not-applied\/"},"modified":"2026-10-23T19:24:19","modified_gmt":"2026-10-23T10:24:19","slug":"google-sheets-conditional-formatting-not-applied","status":"publish","type":"post","link":"https:\/\/cg-method.com\/google\/google-sheets-conditional-formatting-not-applied\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u30fb\u6d88\u305b\u306a\u3044\u3068\u304d\u306e\u76f4\u3057\u65b9"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u3068\u304d\u306f\u3001\u9069\u7528\u7bc4\u56f2\u3001\u53c2\u7167\u5148\u3001\u5024\u306e\u578b\u3001\u30eb\u30fc\u30eb\u306e\u9806\u5e8f\u3092\u5206\u3051\u3066\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5024\u3092\u4e0a\u66f8\u304d\u3057\u305f\u308a\u30a8\u30e9\u30fc\u3092\u898b\u3048\u306a\u304f\u3057\u305f\u308a\u3059\u308b\u524d\u306b\u3001\u65b0\u3057\u3044\u7df4\u7fd2\u30b7\u30fc\u30c8\u3067\u539f\u56e0\u3092\u5207\u308a\u5206\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-formulas-practice-20261002.zip\">\u7df4\u7fd2\u30d6\u30c3\u30af\u30fbGoogle\u7528\u306e\u6570\u5f0f\u30fb\u5165\u529b\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\uff08ZIP\uff09<\/a>\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u65b0\u898f\u306e\u7df4\u7fd2\u30d6\u30c3\u30af\u3067\u8a66\u3057\u3001\u65e2\u5b58\u306e\u5165\u529b\u3084\u8a08\u7b97\u5217\u3078\u8cbc\u308a\u4ed8\u3051\u308b\u524d\u306b\u30b3\u30d4\u30fc\u3092\u4fdd\u5b58\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u78ba\u8a8d\u65e5\u306f2026\u5e7410\u67082\u65e5\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u672c\u6587\u4e2d\u306e\u753b\u9762\u3068\u5b9f\u6e2c\u7d50\u679c\u306f2026\u5e7410\u67082\u65e5\u306e\u8a18\u9332\u3067\u3059\u30022026\u5e7410\u670823\u65e5\u306b\u672c\u6587\u3092\u898b\u76f4\u3057\u3001\u5225\u30b7\u30fc\u30c8\u53c2\u7167\u306e\u5f0f\u306f\u884c\u5168\u4f53\u306e\u5224\u5b9a\u306b\u5408\u3046\u3088\u3046\u5217\u56fa\u5b9a\u3092\u88dc\u3044\u307e\u3057\u305f\u3002\u5909\u66f4\u5f8c\u306e\u5f0f\u306e\u5b9f\u753b\u9762\u306f\u672a\u78ba\u8a8d\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">XLSX\u3092Google Sheets\u3078\u5909\u63db\u3057\u3001Google\u7528TXT\u306e\u6570\u5f0f\u3092\u9069\u7528\u3057\u305f\u7d50\u679c\u3068\u5b9f\u753b\u9762\u3092\u78ba\u8a8d\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n\n<h2 class=\"wp-block-heading\">\u75c7\u72b6\u304b\u3089\u539f\u56e0\u3092\u63a2\u3059<\/h2>\n<p>\u5f53\u3066\u306f\u307e\u308b\u75c7\u72b6\u306e\u884c\u3092\u898b\u3066\u304f\u3060\u3055\u3044\u3002\u539f\u56e0\u304c\u5206\u304b\u308c\u3070\u3001\u8a72\u5f53\u306e\u7bc0\u3060\u3051\u8aad\u3081\u3070\u6e08\u307f\u307e\u3059\u3002<\/p>\n<figure class=\"wp-block-table\" style=\"overflow-x:auto\"><table>\n<thead><tr><th>\u75c7\u72b6<\/th><th>\u3088\u304f\u3042\u308b\u539f\u56e0<\/th><th>\u898b\u308b\u5834\u6240<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>1\u884c\u3060\u3051\u8272\u304c\u4ed8\u3044\u3066\u3001\u307b\u304b\u306e\u884c\u306b\u5e83\u304c\u3089\u306a\u3044<\/td><td>\u9069\u7528\u7bc4\u56f2\u304c1\u884c\u3060\u3051\u3001\u307e\u305f\u306f\u6570\u5f0f\u306e\u76f8\u5bfe\u53c2\u7167\u30fb\u6761\u4ef6\u304c\u610f\u56f3\u3068\u9055\u3046<\/td><td>\u539f\u56e01\u30fb\u539f\u56e02<\/td><\/tr>\n<tr><td>\u884c\u5168\u4f53\u3067\u306f\u306a\u304f\u3001\u6761\u4ef6\u3092\u66f8\u3044\u305f\u5217\u3060\u3051\u8272\u304c\u4ed8\u304f<\/td><td>\u9069\u7528\u7bc4\u56f2\u304c1\u5217\u3057\u304b\u9078\u3079\u3066\u3044\u306a\u3044<\/td><td>\u539f\u56e01<\/td><\/tr>\n<tr><td>\u5857\u3089\u308c\u308b\u884c\u304c1\u884c\u305a\u308c\u308b<\/td><td>\u6570\u5f0f\u304c <code>$C3<\/code> \u306a\u3069\u3001\u5148\u982d\u884c\u3088\u308a\u4e0b\u3092\u6307\u3057\u3066\u3044\u308b<\/td><td>\u539f\u56e01\u30fb\u539f\u56e02<\/td><\/tr>\n<tr><td>\u5168\u90e8\u5857\u3089\u308c\u308b\uff0f\u307e\u3063\u305f\u304f\u5857\u3089\u308c\u306a\u3044<\/td><td><code>$C$2<\/code> \u306e\u3088\u3046\u306b\u884c\u307e\u3067\u56fa\u5b9a\u3057\u3066\u3044\u308b<\/td><td>\u539f\u56e01<\/td><\/tr>\n<tr><td>\u6a2a\u306b\u305a\u308c\u3066\u5225\u306e\u5217\u3092\u898b\u3066\u3044\u308b<\/td><td><code>C2<\/code> \u306e\u3088\u3046\u306b\u5217\u3092\u56fa\u5b9a\u3057\u3066\u3044\u306a\u3044<\/td><td>\u539f\u56e01<\/td><\/tr>\n<tr><td>\u6761\u4ef6\u306b\u5408\u3046\u884c\u306a\u306e\u306b\u8272\u304c\u5909\u308f\u3089\u306a\u3044<\/td><td>\u4e0a\u306b\u3042\u308b\u5225\u306e\u30eb\u30fc\u30eb\u304c\u5148\u306b\u5f53\u305f\u3063\u3066\u3044\u308b<\/td><td>\u539f\u56e03<\/td><\/tr>\n<tr><td>\u898b\u305f\u76ee\u306f\u6570\u5b57\u306a\u306e\u306b\u6570\u5024\u306e\u6761\u4ef6\u304c\u52b9\u304b\u306a\u3044<\/td><td>\u6587\u5b57\u5217\u3068\u3057\u3066\u5165\u529b\u3055\u308c\u3066\u3044\u308b<\/td><td>\u539f\u56e04<\/td><\/tr>\n<tr><td>\u4f55\u3082\u5165\u3063\u3066\u3044\u306a\u3044\u7a7a\u6b04\u307e\u3067\u5857\u3089\u308c\u308b<\/td><td>\u7a7a\u6b04\u304c0\u3084\u300c\u5b8c\u4e86\u3067\u306f\u306a\u3044\u300d\u3068\u5224\u5b9a\u3055\u308c\u3066\u3044\u308b<\/td><td>\u539f\u56e05<\/td><\/tr>\n<tr><td>\u5225\u30b7\u30fc\u30c8\u3092\u53c2\u7167\u3057\u305f\u5f0f\u304c\u30a8\u30e9\u30fc\u306b\u306a\u308b<\/td><td>\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3067\u306f\u4ed6\u30b7\u30fc\u30c8\u3092\u76f4\u63a5\u53c2\u7167\u3067\u304d\u306a\u3044<\/td><td>\u539f\u56e06<\/td><\/tr>\n<tr><td>\u30eb\u30fc\u30eb\u3092\u6d88\u3057\u305f\u306e\u306b\u8272\u304c\u6b8b\u308b<\/td><td>\u624b\u3067\u5857\u3063\u305f\u80cc\u666f\u8272\u304c\u6b8b\u3063\u3066\u3044\u308b<\/td><td>\u30eb\u30fc\u30eb\u306e\u6574\u7406\u306e\u7bc0<\/td><\/tr>\n<tr><td>\u540c\u3058\u3088\u3046\u306a\u30eb\u30fc\u30eb\u304c\u5927\u91cf\u306b\u4e26\u3093\u3067\u3044\u308b<\/td><td>\u30b3\u30d4\u30fc\uff06\u30da\u30fc\u30b9\u30c8\u3067\u30eb\u30fc\u30eb\u304c\u5206\u88c2\u3057\u305f<\/td><td>\u30eb\u30fc\u30eb\u306e\u6574\u7406\u306e\u7bc0<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n<h2 class=\"wp-block-heading\">\u5165\u529b\u4f8b\uff1a\u58f2\u4e0a\u30b7\u30fc\u30c8\u306eA1:E7<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th style=\"min-width:8em !important\">\u54c1\u756a<\/th><th style=\"min-width:8em !important\">\u5206\u985e<\/th><th style=\"min-width:8em !important\">\u72b6\u614b<\/th><th style=\"min-width:8em !important\">\u6570\u91cf<\/th><th style=\"min-width:8em !important\">\u91d1\u984d<\/th><\/tr><\/thead><tbody><tr><td>P01<\/td><td>\u679c\u7269<\/td><td>\u5b8c\u4e86<\/td><td>2<\/td><td>200<\/td><\/tr><tr><td>P02<\/td><td>\u679c\u7269<\/td><td>\u672a\u51e6\u7406<\/td><td>3<\/td><td>300<\/td><\/tr><tr><td>P03<\/td><td>\u6587\u5177<\/td><td>\u5b8c\u4e86<\/td><td>1<\/td><td>150<\/td><\/tr><tr><td>P04<\/td><td>\u679c\u7269<\/td><td>\u5b8c\u4e86<\/td><td>0<\/td><td>0<\/td><\/tr><tr><td>P05<\/td><td>\u6587\u5177<\/td><td>\u5b8c\u4e86<\/td><td>2<\/td><td>240<\/td><\/tr><tr><td>P01<\/td><td>\u679c\u7269<\/td><td>\u5b8c\u4e86<\/td><td>1<\/td><td>90<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u30b7\u30fc\u30c8\u540d\u3092\u300c\u58f2\u4e0a\u300d\u306b\u3057\u30011\u884c\u76ee\u3092\u898b\u51fa\u3057\u30012\uff5e7\u884c\u76ee\u3092\u8868\u306e\u30c7\u30fc\u30bf\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6570\u91cf\u3068\u91d1\u984d\u306f\u6570\u5024\u3067\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">P01\u304c2\u884c\u3042\u308b\u306e\u306f\u3001\u96c6\u8a08\u3068\u691c\u7d22\u306e\u9055\u3044\u3092\u78ba\u304b\u3081\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u884c\u5168\u4f53\u3092C\u5217\u306e\u72b6\u614b\u3067\u5224\u5b9a\u3059\u308b<\/h2>\n\n\n<h3 class=\"wp-block-heading\">\u539f\u56e01\uff1a\u6570\u5f0f\u306e <code>$<\/code> \u306e\u4f4d\u7f6e\u304c\u5408\u3063\u3066\u3044\u306a\u3044<\/h3>\n<p>\u30ab\u30b9\u30bf\u30e0\u6570\u5f0f\u306f\u3001\u9069\u7528\u7bc4\u56f2\u306e<strong>\u5de6\u4e0a\u306e\u30bb\u30eb<\/strong>\u3092\u57fa\u6e96\u306b\u66f8\u304d\u3001\u307b\u304b\u306e\u30bb\u30eb\u306b\u306f\u81ea\u52d5\u3067\u5f53\u3066\u306f\u3081\u3089\u308c\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u52d5\u304b\u3057\u305f\u304f\u306a\u3044\u5074\u306b\u3060\u3051 <code>$<\/code> \u3092\u4ed8\u3051\u307e\u3059\u3002<\/p>\n<figure class=\"wp-block-table\" style=\"overflow-x:auto\"><table>\n<thead><tr><th>\u66f8\u304d\u65b9<\/th><th>\u610f\u5473<\/th><th>\u7d50\u679c<\/th><\/tr><\/thead>\n<tbody>\n<tr><td><code>=$C2=\"\u5b8c\u4e86\"<\/code><\/td><td>\u5217\u3092\u56fa\u5b9a\u3001\u884c\u306f\u52d5\u304f<\/td><td>\u5404\u884c\u304c\u305d\u306e\u884c\u306eC\u5217\u3092\u898b\u308b\uff08\u25ce \u884c\u5168\u4f53\u3092\u5857\u308b\u3068\u304d\u306f\u3053\u308c\uff09<\/td><\/tr>\n<tr><td><code>=$C$2=\"\u5b8c\u4e86\"<\/code><\/td><td>\u5217\u3082\u884c\u3082\u56fa\u5b9a<\/td><td>\u5168\u30bb\u30eb\u304cC2\u3060\u3051\u3092\u898b\u308b\u306e\u3067\u3001\u5168\u90e8\u5857\u308c\u308b\u304b\u5168\u90e8\u5857\u308c\u306a\u3044<\/td><\/tr>\n<tr><td><code>=C2=\"\u5b8c\u4e86\"<\/code><\/td><td>\u3069\u3061\u3089\u3082\u52d5\u304f<\/td><td>\u5217\u3082\u6a2a\u306b\u305a\u308c\u308b\u305f\u3081\u3001D\u5217\u30fbE\u5217\u3092\u898b\u3066\u3057\u307e\u3046<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n<h3 class=\"wp-block-heading\">\u539f\u56e02\uff1a\u9069\u7528\u7bc4\u56f2\u306e\u5148\u982d\u884c\u3068\u3001\u6570\u5f0f\u306e\u884c\u756a\u53f7\u304c\u305a\u308c\u3066\u3044\u308b<\/h3>\n<p>\u300c\u7bc4\u56f2\u306b\u9069\u7528\u300d\u304c <code>A2:E7<\/code> \u306a\u3089\u3001\u6570\u5f0f\u3082<strong>2\u884c\u76ee<\/strong>\u3092\u6307\u3059 <code>=$C2=\"\u5b8c\u4e86\"<\/code> \u306b\u3057\u307e\u3059\u3002<code>$C3<\/code> \u3068\u66f8\u304f\u3068\u3001\u5168\u4f53\u304c1\u884c\u305a\u308c\u3066\u5857\u3089\u308c\u307e\u3059\u3002\u898b\u51fa\u3057\u884c\u3092\u542b\u3081\u3066 <code>A1:E7<\/code> \u3092\u9078\u3093\u3067\u3044\u308b\u5834\u5408\u306f\u3001\u6570\u5f0f\u3082 <code>=$C1=\"\u5b8c\u4e86\"<\/code> \u306b\u306a\u308a\u3001\u898b\u51fa\u3057\u884c\u307e\u3067\u5224\u5b9a\u306e\u5bfe\u8c61\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>\u78ba\u8a8d\u306e\u624b\u9806<\/strong>\uff1a\uff3b\u8868\u793a\u5f62\u5f0f\uff3d\u2192\uff3b\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\uff3d\u3067\u30eb\u30fc\u30eb\u3092\u958b\u304d\u3001\u300c\u7bc4\u56f2\u306b\u9069\u7528\u300d\u306e\u5148\u982d\u30bb\u30eb\u306e\u884c\u756a\u53f7\u3068\u3001\u6570\u5f0f\u306e\u4e2d\u306e\u884c\u756a\u53f7\u304c\u540c\u3058\u304b\u3092\u898b\u307e\u3059\u3002\u540c\u3058\u884c\u3092\u5224\u5b9a\u3057\u305f\u3044\u306e\u306b\u3053\u306e2\u3064\u304c\u4e00\u81f4\u3057\u3066\u3044\u306a\u3044\u3068\u3001\u53c2\u7167\u5148\u304c\u305a\u308c\u307e\u3059\u3002<\/p>\n\n\n\n\n<p class=\"wp-block-paragraph\">\u58f2\u4e0a\u3092\u30b3\u30d4\u30fc\u3057\u3066\u300c\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u300d\u30b7\u30fc\u30c8\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A2:E7\u3092\u9078\u3073\u3001\u300c\u8868\u793a\u5f62\u5f0f\u300d\u2192\u300c\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u300d\u3067\u30ab\u30b9\u30bf\u30e0\u6570\u5f0f\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b8c\u4e86\u306e\u884c\u3092\u6de1\u3044\u7dd1\u306b\u3059\u308b\u5f0f\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=$C2=&quot;\u5b8c\u4e86&quot;<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u56f2\u306e\u5de6\u4e0aA2\u3092\u57fa\u6e96\u306b\u3001C\u5217\u3060\u3051\u3092\u56fa\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u884c\u756a\u53f7\u306f\u56fa\u5b9a\u3057\u306a\u3044\u305f\u3081\u3001\u6b21\u306e\u884c\u3067\u306fC3\u3001C4\u3092\u8abf\u3079\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">$\u3092\u4ed8\u3051\u306a\u3044C2\u3067\u306f\u3001A2\u3078\u306e\u5224\u5b9a\u306fC2\u3001B2\u3078\u306e\u5224\u5b9a\u306fD2\u3001E2\u3078\u306e\u5224\u5b9a\u306fG2\u3078\u305a\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u539f\u56e04\uff1a\u5024\u306e\u578b\u3092\u8868\u793a\u4f4d\u7f6e\u3068\u5206\u3051\u3066\u8abf\u3079\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u7df4\u7fd2\u30b7\u30fc\u30c8\u3060\u3051\u3001E6\u306b\u5148\u982d\u306e\u30a2\u30dd\u30b9\u30c8\u30ed\u30d5\u30a3\u3092\u4ed8\u3051\u3066&#8217;240\u3068\u5165\u529b\u3057\u3001\u6587\u5b57\u5217\u306e240\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5171\u901a\u306e\u58f2\u4e0aE6\u306f\u6570\u5024240\u306e\u307e\u307e\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">F2\u3001G2\u3001H2\u3078\u6b21\u306e\u5f0f\u30921\u3064\u305a\u3064\u5165\u308c\u30017\u884c\u76ee\u307e\u3067\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=ISNUMBER(E2)<\/code><\/pre><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=ISTEXT(E2)<\/code><\/pre><\/div>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=AND(ISNUMBER(E2),E2&gt;100)<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">ISNUMBER\u306f\u6570\u5024\u578b\u3001ISTEXT\u306f\u6587\u5b57\u5217\u578b\u3092\u8abf\u3079\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">H\u5217\u306f\u6570\u5024\u578b\u3067100\u3092\u8d85\u3048\u308b\u304b\u3092\u5224\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5de6\u5bc4\u305b\u30fb\u53f3\u5bc4\u305b\u306f\u624b\u52d5\u3067\u3082\u5909\u66f4\u3067\u304d\u308b\u305f\u3081\u3001\u8868\u793a\u4f4d\u7f6e\u3060\u3051\u3067\u306f\u578b\u3092\u6c7a\u3081\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6570\u5b57\u306e\u8868\u793a\u5f62\u5f0f\u3092\u5909\u3048\u308b\u3053\u3068\u3068\u3001\u6587\u5b57\u3092\u6570\u5024\u306b\u5909\u63db\u3059\u308b\u3053\u3068\u3082\u5206\u3051\u3066\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u78ba\u8a8d\u7d50\u679c\u3068\u5207\u308a\u5206\u3051<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th style=\"min-width:8em !important\">\u6761\u4ef6<\/th><th style=\"min-width:8em !important\">\u7d50\u679c<\/th><\/tr><\/thead><tbody><tr><td>A2:E7\u3001C\u5217\u304c\u5b8c\u4e86<\/td><td>2\u30fb4\u30fb5\u30fb6\u30fb7\u884c\u76ee\u304c\u7dd1\u306b\u306a\u308b\u6761\u4ef6<\/td><\/tr><tr><td>E2\uff1a\u6570\u5024200<\/td><td>F2:TRUE\uff0fG2:FALSE\uff0fH2:TRUE<\/td><\/tr><tr><td>E5\uff1a\u6570\u50240<\/td><td>F5:TRUE\uff0fG5:FALSE\uff0fH5:FALSE<\/td><\/tr><tr><td>E6\uff1a\u6587\u5b57\u5217240<\/td><td>F6:FALSE\uff0fG6:TRUE\uff0fH6:FALSE<\/td><\/tr><tr><td>\u9069\u7528\u7bc4\u56f2\u304cA3\u304b\u3089<\/td><td>\u6570\u5f0f\u306e\u958b\u59cb\u884c\u30823\u3092\u57fa\u6e96\u306b\u305d\u308d\u3048\u308b<\/td><\/tr><tr><td>\u8907\u6570\u30eb\u30fc\u30eb\u304c\u91cd\u306a\u308b<\/td><td>\u5148\u306b\u771f\u306b\u306a\u308b\u30eb\u30fc\u30eb\u3068\u4e26\u3073\u9806\u3092\u78ba\u8a8d<\/td><\/tr><tr><td>\u30eb\u30fc\u30eb\u3092\u6d88\u3057\u3066\u3082\u80cc\u666f\u8272\u304c\u6b8b\u308b<\/td><td>\u5225\u30eb\u30fc\u30eb\u3084\u624b\u52d5\u306e\u80cc\u666f\u8272\u3082\u78ba\u8a8d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">ZIP\u3067\u306f\u6587\u5b57\u5217\u306eE6\u3092\u898b\u5206\u3051\u308b\u6de1\u3044\u9ec4\u8272\u306e\u30eb\u30fc\u30eb\u3082\u542b\u3081\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5f0f\u306e\u8ad6\u7406\u5024\u3001\u5165\u529b\u306e\u578b\u3001XLSX\u306e\u9069\u7528\u7bc4\u56f2\u3068\u30eb\u30fc\u30eb\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Google Sheets\u306e\u5b9f\u753b\u9762\u3067\u3001\u5b8c\u4e86\u3057\u305f\u884c\u304c\u7dd1\u3001\u6587\u5b57\u5217\u306e\u300c240\u300d\u304c\u9ec4\u306b\u306a\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n\n<h3 class=\"wp-block-heading\">\u539f\u56e03\uff1a\u4e0a\u306e\u30eb\u30fc\u30eb\u306b\u8ca0\u3051\u3066\u3044\u308b\uff08\u512a\u5148\u9806\u4f4d\uff09<\/h3>\n<p>Google \u306e\u516c\u5f0f\u30d8\u30eb\u30d7\u306b\u306f\u300c<strong>\u30eb\u30fc\u30eb\u306f\u4e26\u3093\u3067\u3044\u308b\u9806\u306b\u8a55\u4fa1\u3055\u308c\u3001\u6700\u521d\u306b TRUE \u306b\u306a\u3063\u305f\u30eb\u30fc\u30eb\u304c\u305d\u306e\u30bb\u30eb\u307e\u305f\u306f\u7bc4\u56f2\u306e\u66f8\u5f0f\u3092\u6c7a\u3081\u307e\u3059<\/strong>\u300d\u3068\u660e\u8a18\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u4e26\u3079\u66ff\u3048\u306f<strong>\u30c9\u30e9\u30c3\u30b0<\/strong>\u3067\u884c\u3044\u3001\u524a\u9664\u306f\u30eb\u30fc\u30eb\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u5408\u308f\u305b\u3066\u8868\u793a\u3055\u308c\u308b\u524a\u9664\u304b\u3089\u884c\u3044\u307e\u3059\uff08<a href=\"https:\/\/support.google.com\/docs\/answer\/78413\" rel=\"noopener\">Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 \u30a8\u30c7\u30a3\u30bf \u30d8\u30eb\u30d7<\/a>\uff09\u3002<\/p>\n<p>\u305d\u306e\u305f\u3081\u3001\u300cA\u5217\u306b\u5024\u304c\u3042\u308b\u884c\u3092\u7070\u8272\u306b\u3059\u308b\u300d\u30eb\u30fc\u30eb\u304c\u4e0a\u306b\u3042\u308b\u3068\u3001A\u5217\u306b\u5024\u304c\u3042\u308aC\u5217\u304c\u5b8c\u4e86\u306e\u884c\u3067\u306f\u3001\u305d\u306e\u30eb\u30fc\u30eb\u3068\u300c\u5b8c\u4e86\u3092\u7dd1\u306b\u3059\u308b\u300d\u30eb\u30fc\u30eb\u304c\u91cd\u306a\u308a\u307e\u3059\u3002\u540c\u3058\u30bb\u30eb\u3067\u306f\u5148\u306b\u771f\u306b\u306a\u308b\u7070\u8272\u304c\u512a\u5148\u3055\u308c\u307e\u3059\u3002\u610f\u56f3\u3057\u305f\u8272\u304c\u51fa\u306a\u3044\u3068\u304d\u306f\u3001\u30eb\u30fc\u30eb\u3092\u6d88\u3059\u524d\u306b<strong>\u9806\u756a\u3092\u5165\u308c\u66ff\u3048\u3066<\/strong>\u8a66\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u7d30\u304b\u3044\u6761\u4ef6\uff08\u4f8b\u5916\uff09\u3092\u4e0a\u306b\u3001\u5e83\u3044\u6761\u4ef6\u3092\u4e0b\u306b\u7f6e\u304f\u306e\u304c\u57fa\u672c\u306e\u4e26\u3079\u65b9\u3067\u3059\u3002<\/p>\n\n<h3 class=\"wp-block-heading\">\u539f\u56e05\uff1a\u7a7a\u6b04\u307e\u3067\u52dd\u624b\u306b\u5857\u3089\u308c\u308b<\/h3>\n<p>\u7a7a\u306e\u30bb\u30eb\u306f\u3001\u6570\u5024\u3068\u3057\u3066\u6bd4\u3079\u308b\u30680\u306e\u3088\u3046\u306b\u6271\u308f\u308c\u3001\u6587\u5b57\u5217\u3068\u3057\u3066\u6bd4\u3079\u308b\u3068\u300c\u5b8c\u4e86\u3067\u306f\u306a\u3044\u300d\u3068\u5224\u5b9a\u3055\u308c\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u6b21\u306e\u3088\u3046\u306a\u5f0f\u3067\u306f\u7a7a\u6b04\u304c\u30d2\u30c3\u30c8\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li><code>=$D2&lt;=100<\/code> \u2192 \u7a7a\u6b04\u304c\u6761\u4ef6\u306b\u5165\u308b<\/li>\n<li><code>=$C2&lt;&gt;\"\u5b8c\u4e86\"<\/code> \u2192 \u7a7a\u6b04\u304c\u300c\u5b8c\u4e86\u3067\u306f\u306a\u3044\u300d\u3068\u3057\u3066\u6761\u4ef6\u306b\u5165\u308b<\/li>\n<\/ul>\n<p>\u7a7a\u6b04\u3092\u9664\u304f\u306b\u306f\u3001AND \u3067\u300c\u7a7a\u6b04\u3067\u306a\u3044\u300d\u3068\u3044\u3046\u6761\u4ef6\u3092\u8db3\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"wp-block-code\" style=\"max-width:100%;overflow-x:auto\"><code>=AND($D2&lt;&gt;\"\", $D2&lt;=100)\n=AND($C2&lt;&gt;\"\", $C2&lt;&gt;\"\u5b8c\u4e86\")<\/code><\/pre>\n<p>\u6570\u5f0f\u306e\u5f62\u3067\u9664\u304d\u305f\u3044\u5834\u5408\u306f <code>=AND(NOT(ISBLANK($D2)), $D2&lt;=100)<\/code> \u3067\u3082\u672c\u5f53\u306b\u672a\u5165\u529b\u306e\u30bb\u30eb\u3092\u9664\u3051\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u6570\u5f0f\u304c\u7a7a\u6587\u5b57\u5217\u3092\u8fd4\u3059\u30bb\u30eb\u306fISBLANK\u3067\u306f\u7a7a\u767d\u6271\u3044\u306b\u306a\u308a\u307e\u305b\u3093\u3002\u6570\u5f0f\u306e\u7a7a\u6587\u5b57\u5217\u3082\u9664\u304d\u305f\u3044\u5834\u5408\u306f\u3001\u4e0a\u306e\u300c&lt;&gt;&#8221;&#8221;\u300d\u306e\u6761\u4ef6\u3092\u4f7f\u3044\u307e\u3059\u3002<strong>\u6761\u4ef6\u306e\u5148\u982d\u306b\u300c\u7a7a\u6b04\u3067\u306a\u3044\u300d\u3092\u7f6e\u304f<\/strong>\u3068\u899a\u3048\u3066\u304a\u304f\u3068\u3001\u307b\u3068\u3093\u3069\u306e\u5dfb\u304d\u8fbc\u307f\u304c\u9632\u3052\u307e\u3059\u3002<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u539f\u56e06\uff1a\u5225\u30b7\u30fc\u30c8\u3092\u53c2\u7167\u3059\u308b\u5f0f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7df4\u7fd2\u30b7\u30fc\u30c8\u306eA2:E7\u3067\u3001\u58f2\u4e0a\u306e\u54c1\u756a\u306b\u5b58\u5728\u3059\u308b\u884c\u3092\u8abf\u3079\u308b\u306a\u3089\u6b21\u306e\u5f0f\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">INDIRECT\u306e\u53c2\u7167\u7bc4\u56f2\u306f\u58f2\u4e0a2\uff5e7\u884c\u76ee\u306b\u9650\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u884c\u5168\u4f53\u3092\u5224\u5b9a\u3059\u308b\u305f\u3081\u3001\u6761\u4ef6\u306b\u4f7f\u3046\u54c1\u756a\u306f$A2\u3068\u3057\u3066A\u5217\u3092\u56fa\u5b9a\u3057\u307e\u3059\u3002\u6570\u5f0f\u6b04\u306b\u8aac\u660e\u6587\u306f\u4e00\u7dd2\u306b\u8cbc\u308a\u4ed8\u3051\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=COUNTIF(INDIRECT(&quot;\u58f2\u4e0a!$A$2:$A$7&quot;),$A2)&gt;0<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u904e\u53bb\u306e\u8a18\u9332\u3067\u306f\u54c1\u756a\u306e\u5224\u5b9a\u7d50\u679c\u30926\u884c\u3068\u3082TRUE\u3068\u3057\u3066\u3044\u307e\u3059\u3002\u73fe\u5728\u63b2\u8f09\u3057\u3066\u3044\u308b\u5f0f\u306f\u3001\u6a2a\u65b9\u5411\u3078\u9069\u7528\u3057\u3066\u3082\u54c1\u756a\u5217\u304c\u305a\u308c\u306a\u3044\u3088\u3046$A2\u3078\u4fee\u6b63\u3057\u305f\u3082\u306e\u3067\u3059\u3002\u30b3\u30d4\u30fc\u3057\u305f\u7df4\u7fd2\u8868\u3067\u3001\u884c\u5168\u4f53\u306e\u8272\u3068\u4ed6\u30eb\u30fc\u30eb\u3068\u306e\u512a\u5148\u9806\u4f4d\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5225\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u3080\u5834\u5408\u306fINDIRECT\u3060\u3051\u3067\u6e08\u307e\u305b\u305a\u3001<a href=\"https:\/\/cg-method.com\/google\/google-sheets-importrange-query\/\">IMPORTRANGE\u3067\u540c\u3058\u30d6\u30c3\u30af\u3078\u53d6\u308a\u8fbc\u3080\u624b\u9806<\/a>\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b3\u30d4\u30fc\u6642\u306e\u78ba\u8a8d\u3068\u5143\u306e\u72b6\u614b\u3078\u306e\u623b\u3057\u65b9<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30eb\u30fc\u30eb\u306e\u3042\u308b\u30bb\u30eb\u3092\u30b3\u30d4\u30fc\u3059\u308b\u3068\u8cbc\u308a\u4ed8\u3051\u5148\u306b\u3082\u30eb\u30fc\u30eb\u304c\u9069\u7528\u3055\u308c\u308b\u305f\u3081\u3001\u8cbc\u308a\u4ed8\u3051\u5f8c\u306e\u7bc4\u56f2\u3068\u53c2\u7167\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5143\u3078\u623b\u3059\u3068\u304d\u306f\u3001\u5bfe\u8c61\u30bb\u30eb\u3092\u9078\u3093\u3067\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u30d1\u30cd\u30eb\u3092\u958b\u304d\u3001\u4eca\u56de\u8ffd\u52a0\u3057\u305f\u30eb\u30fc\u30eb\u3060\u3051\u3092\u524a\u9664\u30a2\u30a4\u30b3\u30f3\u3067\u5916\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5148\u306b\u63a7\u3048\u305f\u65e2\u5b58\u30eb\u30fc\u30eb\u306e\u7bc4\u56f2\u30fb\u6570\u5f0f\u30fb\u9806\u5e8f\u306f\u6b8b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u66f8\u5f0f\u5168\u4f53\u3092\u6d88\u3059\u64cd\u4f5c\u3092\u3001\u4eca\u56de\u306e1\u30eb\u30fc\u30eb\u3060\u3051\u3092\u623b\u3059\u4ee3\u308f\u308a\u306b\u4f7f\u308f\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8272\u304c\u306a\u3044\u3053\u3068\u3068\u3001\u5143\u306e\u6570\u5f0f\u304c\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3044\u306a\u3044\u3053\u3068\u306f\u5225\u306b\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n\n<h3 class=\"wp-block-heading\">\u30eb\u30fc\u30eb\u304c\u91cd\u8907\u30fb\u5206\u88c2\u3057\u305f\u3068\u304d\u306e\u6574\u7406<\/h3>\n<p>\u884c\u3092\u30b3\u30d4\u30fc\uff06\u30da\u30fc\u30b9\u30c8\u3059\u308b\u3068\u3001\u540c\u3058\u6761\u4ef6\u306e\u30eb\u30fc\u30eb\u304c\u7bc4\u56f2\u3054\u3068\u306b\u5206\u304b\u308c\u3066\u5897\u3048\u3066\u3044\u304d\u307e\u3059\u300210\u500b\u300120\u500b\u3068\u4e26\u3076\u3068\u3001\u3069\u308c\u304c\u52b9\u3044\u3066\u3044\u308b\u304b\u5206\u304b\u3089\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<ol>\n<li>\uff3b\u8868\u793a\u5f62\u5f0f\uff3d\u2192\uff3b\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\uff3d\u3092\u958b\u304d\u3001\u30eb\u30fc\u30eb\u306e\u4e00\u89a7\u3092\u4e0a\u304b\u3089\u898b\u308b<\/li>\n<li>\u6570\u5f0f\u3060\u3051\u3067\u306a\u304f\u8272\u306a\u3069\u306e\u66f8\u5f0f\u3068\u512a\u5148\u9806\u4f4d\u3082\u540c\u3058\u76ee\u7684\u306e\u30eb\u30fc\u30eb\u3092\u898b\u3064\u3051\u308b<\/li>\n<li>\u6b8b\u30591\u3064\u3092\u6c7a\u3081\u3001\u5fc5\u8981\u306a\u7bc4\u56f2\u3060\u3051\u306b\u9069\u7528\u3059\u308b\u3002\u4f8b\u3048\u3070A2:E100\u3078\u7d71\u5408\u3059\u308b\u306a\u3089\u3001\u9593\u306e\u884c\u3082\u5bfe\u8c61\u306b\u3057\u3066\u3088\u3044\u304b\u3001\u6570\u5f0f\u306e\u57fa\u6e96\u884c\u304c\u5408\u3046\u304b\u3092\u78ba\u8a8d\u3059\u308b<\/li>\n<li>\u6b8b\u308a\u3092\u30eb\u30fc\u30eb\u3054\u3068\u306b\u524a\u9664\u3059\u308b\uff08\u524a\u9664\u524d\u306b\u7bc4\u56f2\u30fb\u6570\u5f0f\u30fb\u66f8\u5f0f\u30fb\u512a\u5148\u9806\u4f4d\u3092\u63a7\u3048\u3001\u6b8b\u3059\u30eb\u30fc\u30eb\u304c\u52b9\u3044\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304b\u3089\u6d88\u3059\uff09<\/li>\n<\/ol>\n<p><strong>\u8cbc\u308a\u4ed8\u3051\u308b\u3068\u304d\u306e\u4e88\u9632<\/strong>\uff1a\u5024\u3060\u3051\u3092\u8cbc\u308c\u3070\u66f8\u5f0f\u306e\u30eb\u30fc\u30eb\u306f\u5897\u3048\u307e\u305b\u3093\uff08\u8cbc\u308a\u4ed8\u3051\u5148\u3067\uff3b\u7de8\u96c6\uff3d\u2192\uff3b\u7279\u5225\u306a\u8cbc\u308a\u4ed8\u3051\uff3d\u2192\uff3b\u5024\u306e\u307f\u8cbc\u308a\u4ed8\u3051\uff3d\uff09\u3002<\/p>\n<p><strong>\u30eb\u30fc\u30eb\u3092\u6d88\u3057\u3066\u3082\u8272\u304c\u6b8b\u308b\u5834\u5408<\/strong>\uff1a\u624b\u52d5\u306e\u80cc\u666f\u8272\u3001\u5225\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3001\u4ea4\u4e92\u306e\u80cc\u666f\u8272\u306a\u3069\u304c\u6b8b\u3063\u3066\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u30eb\u30fc\u30eb\u524a\u9664\u3068\u3001\u5857\u308a\u3064\u3076\u3057\u306e\u8272\u306e\u89e3\u9664\uff08\u5857\u308a\u3064\u3076\u3057\u306e\u8272\u3092\u300c\u306a\u3057\u300d\u306b\u3059\u308b\uff09\u306f\u5225\u306e\u64cd\u4f5c\u3067\u3059\u3002<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u516c\u5f0f\u8cc7\u6599<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ed5\u69d8\u306f<a href=\"https:\/\/support.google.com\/docs\/answer\/78413?hl=ja\">\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u53c2\u7167\u30fb\u9806\u5e8f\u30fb\u524a\u9664<\/a>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"370\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-formulas-04-23099-native.jpg\" alt=\"Google Sheets\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3002\u5b8c\u4e86\u884c\u306f\u7dd1\u3001\u6587\u5b57\u5217240\u306e\u30bb\u30eb\u306f\u9ec4\u3002\" class=\"wp-image-23531\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-formulas-04-23099-native.jpg 850w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-formulas-04-23099-native-300x131.jpg 300w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-formulas-04-23099-native-768x334.jpg 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><figcaption class=\"wp-element-caption\">\u7df4\u7fd2\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u305fGoogle Sheets\u306e\u5b9f\u753b\u9762\u3002\u6587\u5b57\u5217\u306e240\u306b\u306f\u3001\u6570\u5024\u306e\u6761\u4ef6\u3092\u9069\u7528\u3057\u307e\u305b\u3093\u3002<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u7df4\u7fd2\u30d5\u30a1\u30a4\u30eb\u306e\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7df4\u7fd2\u306e\u5165\u529b\u3068\u51fa\u529b\u306f\u672c\u6587\u306e\u30bb\u30eb\u756a\u5730\u3067\u305d\u308d\u3048\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Google\u7528TXT\u3068XLSX\u306e\u4e92\u63db\u6027\u306e\u9055\u3044\u306f\u3001\u5404\u8a18\u4e8b\u3068ZIP\u306eREADME\u3067\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/google-sheets-conditional-formatting-row-highlight-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-sheets-conditional-formatting-row-highlight\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u7279\u5b9a\u306e\u6761\u4ef6\u3067\u884c\u3060\u3051\u3092\u81ea\u52d5\u3067\u5857\u308a\u3064\u3076\u3059\u65b9\u6cd5\u2502\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u72b6\u614b\u306e\u5217\u3092\u5224\u5b9a\u3057\u3001\u6761\u4ef6\u306b\u5408\u3046\u884c\u5168\u4f53\u3078\u80cc\u666f\u8272\u3092\u4ed8\u3051\u307e\u3059\u3002 A\u5217\u306e\u5b8c\u4e86\u3092\u6761\u4ef6\u306b\u3057\u3066\u3001A2:D7\u306e\u4e2d\u3067\u4e00\u81f4\u3059\u308b\u884c\u3060\u3051\u3092\u30b0\u30ec\u30fc\u306b\u3059\u308b\u4f8b\u3067\u3059\u3002 5\u8a18\u4e8b\u5171\u901a\u306e\u7df4\u7fd2\u30d5\u30a1\u30a4\u30eb\uff08ZIP\uff09&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/google-sheets-alternate-group-color-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-sheets-alternate-group-color\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u540c\u3058\u5024\u3054\u3068\u306b\u4ea4\u4e92\u306b\u5857\u308a\u5206\u3051\u308b\u65b9\u6cd5\u2502\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u540c\u3058\u5024\u304c\u7d9a\u304f\u884c\u30921\u3064\u306e\u30b0\u30eb\u30fc\u30d7\u3068\u3057\u3066\u3001\u30b0\u30eb\u30fc\u30d7\u304c\u5909\u308f\u308b\u305f\u3073\u306b\u80cc\u666f\u8272\u3092\u4ea4\u4e92\u306b\u3057\u307e\u3059\u3002 \u524d\u306e\u884c\u3068\u306e\u6bd4\u8f03\u3067\u88dc\u52a9\u756a\u53f7\u3092\u4f5c\u308b\u3068\u3001\u540c\u3058\u5024\u304c\u5f8c\u304b\u3089\u518d\u767b\u5834\u3059\u308b\u5834\u5408\u3082\u533a\u5225\u3067\u304d\u307e&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/06\/spreadsheet-group-coloring-gas-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/spreadsheet-group-coloring-gas\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u9023\u7d9a\u30c7\u30fc\u30bf\u3092\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\u8272\u3067\u5857\u308a\u5206\u3051\u308b\u65b9\u6cd5<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">A\u5217\u306e\u9023\u7d9a\u3057\u305f\u540c\u3058\u5024\u3092\u30b0\u30eb\u30fc\u30d7\u3068\u3057\u3066\u8272\u5206\u3051\u3057\u307e\u3059\u3002 \u5148\u982d\u884c\u306f\u898b\u51fa\u3057\u3068\u3057\u3066\u9664\u304d\u3001\u5143\u30b7\u30fc\u30c8\u3092\u30b3\u30d4\u30fc\u3057\u3066\u304b\u3089\u30b3\u30d4\u30fc\u306eA\u5217\u3060\u3051\u3092\u5909\u66f4\u3057\u307e\u3059\u3002 \u6700\u7d42\u78ba\u8a8d\u306f2026\u5e7410\u67082\u65e5\u3067\u3059&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<a href=\"https:\/\/support.google.com\/docs\/answer\/78413?hl=ja\" class=\"c-blogLink -external\" data-style=\"text\" target=\"_blank\" rel=\"noopener noreferrer\">\n\t\t\t\t<!-- <i class=\"c-blogLink__icon icon-link\" role=\"presentation\"><\/i> -->\n\t\t\t\t<span class=\"c-blogLink__icon\">\n\t\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"swl-svg-externalLink __svg\" width=\"1em\" height=\"1em\" viewBox=\"0 0 48 48\" role=\"img\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M44 2H30c-1.1 0-2 .9-2 2s.9 2 2 2h9.2L24 21.2c-.8.8-.8 2 0 2.8s2 .8 2.8 0L42 8.8V18c0 1.1.9 2 2 2s2-.9 2-2V4c0-1.1-.9-2-2-2z\" \/><path d=\"M41 27c-1.1 0-2 .9-2 2v10c0 1.1-.9 2-2 2H9c-1.1 0-2-.9-2-2V11c0-1.1.9-2 2-2h10c1.1 0 2-.9 2-2s-.9-2-2-2H9c-3.3 0-6 2.7-6 6v28c0 3.3 2.7 6 6 6h28c3.3 0 6-2.7 6-6V29c0-1.1-.9-2-2-2z\" \/><\/svg>\t\t\t\t<\/span>\n\t\t\t\t<span class=\"c-blogLink__text\">Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u30eb\u30fc\u30eb\u3092\u4f7f\u7528\u3059\u308b &#8211; \u30d1\u30bd\u30b3\u30f3 &#8211; Google \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 \u30a8\u30c7\u30a3\u30bf \u30d8\u30eb&#8230;<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u3088\u304f\u3042\u308b\u8cea\u554f\uff1a\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u3068\u304d\u306e\u30c1\u30a7\u30c3\u30af\u30ea\u30b9\u30c8<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u3068\u304d\u306f\u3001\u4f55\u3092\u78ba\u8a8d\u3057\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9069\u7528\u7bc4\u56f2\u3001\u53c2\u7167\u5148\u3001\u5024\u306e\u578b\u3001\u30eb\u30fc\u30eb\u306e\u9806\u5e8f\u3092\u5206\u3051\u3066\u78ba\u8a8d\u3057\u307e\u3059\u3002\u5024\u3092\u4e0a\u66f8\u304d\u3057\u305f\u308a\u3001\u30a8\u30e9\u30fc\u3092\u898b\u3048\u306a\u304f\u3057\u305f\u308a\u3059\u308b\u524d\u306b\u3001\u65b0\u3057\u3044\u7df4\u7fd2\u30b7\u30fc\u30c8\u3067\u539f\u56e0\u3092\u5207\u308a\u5206\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1\u884c\u3060\u3051\u8272\u304c\u4ed8\u3044\u3066\u3001\u307b\u304b\u306e\u884c\u306b\u5e83\u304c\u3089\u306a\u3044\u306e\u306f\u3001\u306a\u305c\u3067\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305a\u9069\u7528\u7bc4\u56f2\u304c\u5fc5\u8981\u306a\u884c\u307e\u3067\u542b\u307e\u308c\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002\u6b21\u306b\u3001\u6570\u5f0f\u306e\u884c\u756a\u53f7\u3068\u56fa\u5b9a\u53c2\u7167\u304c\u610f\u56f3\u3069\u304a\u308a\u304b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u30021\u884c\u3060\u3051\u8272\u304c\u4ed8\u304f\u3068\u3044\u3046\u75c7\u72b6\u3060\u3051\u3067\u3001\u884c\u756a\u53f7\u306e\u305a\u308c\u304c\u539f\u56e0\u3068\u306f\u65ad\u5b9a\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u884c\u5168\u4f53\u3067\u306f\u306a\u304f\u3001\u6761\u4ef6\u3092\u66f8\u3044\u305f\u5217\u3060\u3051\u8272\u304c\u4ed8\u304f\u306e\u306f\u3001\u306a\u305c\u3067\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9069\u7528\u7bc4\u56f2\u304c1\u5217\u3057\u304b\u9078\u3079\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u539f\u56e0\u3068\u3057\u3066\u3001\u8a18\u4e8b\u306e\u75c7\u72b6\u8868\u306b\u6319\u3052\u3089\u308c\u3066\u3044\u307e\u3059\u3002\u6570\u5f0f\u306e$\u306e\u4f4d\u7f6e\u3082\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6761\u4ef6\u306b\u5408\u3046\u884c\u306a\u306e\u306b\u3001\u8272\u304c\u5909\u308f\u3089\u306a\u3044\u306e\u306f\u3001\u306a\u305c\u3067\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u306b\u3042\u308b\u5225\u306e\u30eb\u30fc\u30eb\u304c\u3001\u5148\u306b\u5f53\u305f\u3063\u3066\u3044\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002Google\u306e\u516c\u5f0f\u30d8\u30eb\u30d7\u3067\u306f\u3001\u30eb\u30fc\u30eb\u306f\u4e26\u3093\u3067\u3044\u308b\u9806\u306b\u8a55\u4fa1\u3055\u308c\u3001\u6700\u521d\u306bTRUE\u306b\u306a\u3063\u305f\u30eb\u30fc\u30eb\u304c\u3001\u305d\u306e\u30bb\u30eb\u307e\u305f\u306f\u7bc4\u56f2\u306e\u66f8\u5f0f\u3092\u6c7a\u3081\u308b\u3068\u8aac\u660e\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u30eb\u30fc\u30eb\u3092\u6d88\u3059\u524d\u306b\u3001\u9806\u756a\u3092\u5165\u308c\u66ff\u3048\u3066\u8a66\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u898b\u305f\u76ee\u306f\u6570\u5b57\u306a\u306e\u306b\u3001\u6570\u5024\u306e\u6761\u4ef6\u304c\u52b9\u304b\u306a\u3044\u306e\u306f\u3001\u306a\u305c\u3067\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6587\u5b57\u5217\u3068\u3057\u3066\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u5024\u306e\u578b\u3092\u3001\u8868\u793a\u4f4d\u7f6e\u3068\u5206\u3051\u3066\u8abf\u3079\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u7a7a\u6b04\u307e\u3067\u5857\u3089\u308c\u3066\u3057\u307e\u3046\u3068\u304d\u306f\u3001\u3069\u3046\u3057\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7a7a\u306e\u30bb\u30eb\u306f\u3001\u6570\u5024\u3068\u3057\u3066\u6bd4\u3079\u308b\u30680\u306e\u3088\u3046\u306b\u6271\u308f\u308c\u3001\u6587\u5b57\u5217\u3068\u3057\u3066\u6bd4\u3079\u308b\u3068\u300c\u5b8c\u4e86\u3067\u306f\u306a\u3044\u300d\u3068\u5224\u5b9a\u3055\u308c\u308b\u305f\u3081\u3067\u3059\u3002AND\u3067\u300c\u7a7a\u6b04\u3067\u306a\u3044\u300d\u3068\u3044\u3046\u6761\u4ef6\u3092\u8db3\u3057\u307e\u3059\u3002\u6761\u4ef6\u306e\u5148\u982d\u306b\u300c\u7a7a\u6b04\u3067\u306a\u3044\u300d\u3092\u7f6e\u304f\u3068\u3001\u307b\u3068\u3093\u3069\u306e\u5dfb\u304d\u8fbc\u307f\u304c\u9632\u3052\u308b\u3068\u3001\u8a18\u4e8b\u306f\u8aac\u660e\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5225\u306e\u30b7\u30fc\u30c8\u3092\u53c2\u7167\u3059\u308b\u5f0f\u306f\u3001\u4f7f\u3048\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">INDIRECT\u3092\u4f7f\u3063\u305f\u4f8b\u3092\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002\u5225\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u3080\u5834\u5408\u306f\u3001INDIRECT\u3060\u3051\u3067\u6e08\u307e\u305b\u305a\u3001IMPORTRANGE\u3067\u540c\u3058\u30d6\u30c3\u30af\u3078\u53d6\u308a\u8fbc\u3080\u624b\u9806\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u3068\u304d\u306f\u3001\u9069\u7528\u7bc4\u56f2\u3001\u53c2\u7167\u5148\u3001\u5024\u306e\u578b\u3001\u30eb\u30fc\u30eb\u306e\u9806\u5e8f\u3092\u5206\u3051\u3066\u78ba\u8a8d\u3057\u307e\u3059\u3002 \u5024\u3092\u4e0a\u66f8\u304d\u3057\u305f\u308a\u30a8\u30e9\u30fc\u3092\u898b\u3048\u306a\u304f\u3057\u305f\u308a\u3059\u308b\u524d\u306b\u3001\u65b0\u3057\u3044\u7df4\u7fd2\u30b7\u30fc\u30c8\u3067\u539f\u56e0\u3092\u5207\u308a\u5206\u3051\u307e\u3059\u3002 \u7df4\u7fd2\u30d6\u30c3\u30af\u30fbGoogle\u7528\u306e\u6570\u5f0f\u30fb\u5165\u529b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":23109,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","book_review_data":"","footnotes":"","ssp_meta_title":"\u3010\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3011\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u539f\u56e0\u3068\u76f4\u3057\u65b9\uff5c\u8272\u304c\u5909\u308f\u3089\u306a\u3044\u30fb\u305a\u308c\u308b","ssp_meta_description":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u304c\u52b9\u304b\u306a\u3044\u30fb\u8272\u304c\u53cd\u6620\u3055\u308c\u306a\u3044\u30fb\u884c\u304c\u305a\u308c\u308b\u539f\u56e0\u3092\u75c7\u72b6\u5225\u306b\u89e3\u8aac\u3002$\u306e\u4ed8\u3051\u65b9\u3001\u9069\u7528\u7bc4\u56f2\u306e\u5148\u982d\u884c\u30eb\u30fc\u30eb\u3001\u30eb\u30fc\u30eb\u306e\u512a\u5148\u9806\u4f4d\u3001\u7a7a\u767d\u30bb\u30eb\u306e\u5dfb\u304d\u8fbc\u307f\u9632\u6b62\u3001\u5225\u30b7\u30fc\u30c8\u53c2\u7167\u3001\u5206\u88c2\u3057\u305f\u30eb\u30fc\u30eb\u306e\u6574\u7406\u307e\u3067\u3002"},"categories":[17],"tags":[],"class_list":["post-23099","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets"],"_links":{"self":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/23099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/comments?post=23099"}],"version-history":[{"count":9,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/23099\/revisions"}],"predecessor-version":[{"id":23798,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/23099\/revisions\/23798"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media\/23109"}],"wp:attachment":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media?parent=23099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/categories?post=23099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/tags?post=23099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}