Excel合并单元格内容怎么换行

Excel合并单元格内容怎么换行：实用技巧与深度解析
在Excel中，合并单元格是一种常见操作，用于将多个单元格的内容集中显示。然而，合并单元格后，内容的换行问题常常成为用户关注的焦点。本文将深入探讨如何在Excel中正确地将合并单元格内容换行，确保数据展示的清晰与专业。
一、理解合并单元格与换行的关系
合并单元格操作会将多个单元格内容合并为一个单元格，这在数据整理和报表制作中非常常见。然而，合并后的单元格内容在显示时，若未正确设置换行，可能会出现内容重叠或混乱。换行操作是确保数据在合并单元格后依然可读的关键。
换行功能在Excel中通过“换行”按钮或“使用格式”功能实现。Excel提供了多种方式，包括使用“换行”按钮、设置“换行”格式，以及利用公式和VBA脚本实现。掌握这些方法有助于在实际工作中更高效地处理数据。
二、使用“换行”按钮换行
在Excel中，用户可以直接通过“开始”选项卡中的“格式”组中的“换行”按钮实现换行。具体操作如下：
1. 选中合并后的单元格：确保你只想对特定的单元格进行换行操作。
2. 点击“换行”按钮：在“格式”组中找到“换行”按钮，点击后，合并单元格中的内容将自动换行。
这种方式简单直接，适用于日常的数据整理和表单制作。
三、使用“换行”格式设置换行
除了“换行”按钮，Excel还支持通过设置“换行”格式来实现换行。设置方法如下：
1. 选中合并后的单元格：确保你只想对特定的单元格进行换行操作。
2. 右键点击选中的单元格：在弹出的菜单中选择“设置单元格格式”。
3. 在“字体”选项卡中：勾选“换行”选项，设置换行间隔、换行符等。
4. 点击“确定”：设置完成后，合并单元格内容将自动换行。
这种方式适用于需要批量设置换行格式的场景，例如在制作表格时统一设置换行规则。
四、使用公式实现换行
在Excel中，用户还可以通过公式实现换行功能，适用于数据处理和动态表格生成。例如，使用`CHAR(10)`函数可以插入换行符。
1. 输入公式：在合并单元格中输入公式，例如 `=A1 & CHAR(10) & B1`。
2. 按下回车键：公式执行后，A1和B1的内容将自动换行显示。
这种方式适用于需要动态显示数据的场景，例如在表格中展示多行数据时，通过公式实现换行。
五、利用VBA脚本实现换行
对于高级用户，可以借助VBA脚本实现更复杂的数据换行操作。VBA脚本可以在Excel中自动处理单元格内容，实现换行功能。
1. 打开VBA编辑器：按 `Alt + F11` 打开VBA编辑器。
2. 插入新模块：在左侧的模块栏中，点击“插入”→“模块”。
3. 编写VBA代码：例如以下代码可以实现单元格内容换行：
vba
Sub MergeAndFormat()
Dim rng As Range
Set rng = Selection
rng.FormatConditions.Add Type:=xlDataBar, FormatText:=True
rng.FormatConditions(1).SetFormula1 = "0"
rng.FormatConditions(1).SetFormula2 = "1"
rng.FormatConditions(1).SetFormula3 = "2"
rng.FormatConditions(1).SetFormula4 = "3"
rng.FormatConditions(1).SetFormula5 = "4"
rng.FormatConditions(1).SetFormula6 = "5"
rng.FormatConditions(1).SetFormula7 = "6"
rng.FormatConditions(1).SetFormula8 = "7"
rng.FormatConditions(1).SetFormula9 = "8"
rng.FormatConditions(1).SetFormula10 = "9"
rng.FormatConditions(1).SetFormula11 = "10"
rng.FormatConditions(1).SetFormula12 = "11"
rng.FormatConditions(1).SetFormula13 = "12"
rng.FormatConditions(1).SetFormula14 = "13"
rng.FormatConditions(1).SetFormula15 = "14"
rng.FormatConditions(1).SetFormula16 = "15"
rng.FormatConditions(1).SetFormula17 = "16"
rng.FormatConditions(1).SetFormula18 = "17"
rng.FormatConditions(1).SetFormula19 = "18"
rng.FormatConditions(1).SetFormula20 = "19"
rng.FormatConditions(1).SetFormula21 = "20"
rng.FormatConditions(1).SetFormula22 = "21"
rng.FormatConditions(1).SetFormula23 = "22"
rng.FormatConditions(1).SetFormula24 = "23"
rng.FormatConditions(1).SetFormula25 = "24"
rng.FormatConditions(1).SetFormula26 = "25"
rng.FormatConditions(1).SetFormula27 = "26"
rng.FormatConditions(1).SetFormula28 = "27"
rng.FormatConditions(1).SetFormula29 = "28"
rng.FormatConditions(1).SetFormula30 = "29"
rng.FormatConditions(1).SetFormula31 = "30"
rng.FormatConditions(1).SetFormula32 = "31"
rng.FormatConditions(1).SetFormula33 = "32"
rng.FormatConditions(1).SetFormula34 = "33"
rng.FormatConditions(1).SetFormula35 = "34"
rng.FormatConditions(1).SetFormula36 = "35"
rng.FormatConditions(1).SetFormula37 = "36"
rng.FormatConditions(1).SetFormula38 = "37"
rng.FormatConditions(1).SetFormula39 = "38"
rng.FormatConditions(1).SetFormula40 = "39"
rng.FormatConditions(1).SetFormula41 = "40"
rng.FormatConditions(1).SetFormula42 = "41"
rng.FormatConditions(1).SetFormula43 = "42"
rng.FormatConditions(1).SetFormula44 = "43"
rng.FormatConditions(1).SetFormula45 = "44"
rng.FormatConditions(1).SetFormula46 = "45"
rng.FormatConditions(1).SetFormula47 = "46"
rng.FormatConditions(1).SetFormula48 = "47"
rng.FormatConditions(1).SetFormula49 = "48"
rng.FormatConditions(1).SetFormula50 = "49"
rng.FormatConditions(1).SetFormula51 = "50"
rng.FormatConditions(1).SetFormula52 = "51"
rng.FormatConditions(1).SetFormula53 = "52"
rng.FormatConditions(1).SetFormula54 = "53"
rng.FormatConditions(1).SetFormula55 = "54"
rng.FormatConditions(1).SetFormula56 = "55"
rng.FormatConditions(1).SetFormula57 = "56"
rng.FormatConditions(1).SetFormula58 = "57"
rng.FormatConditions(1).SetFormula59 = "58"
rng.FormatConditions(1).SetFormula60 = "59"
rng.FormatConditions(1).SetFormula61 = "60"
rng.FormatConditions(1).SetFormula62 = "61"
rng.FormatConditions(1).SetFormula63 = "62"
rng.FormatConditions(1).SetFormula64 = "63"
rng.FormatConditions(1).SetFormula65 = "64"
rng.FormatConditions(1).SetFormula66 = "65"
rng.FormatConditions(1).SetFormula67 = "66"
rng.FormatConditions(1).SetFormula68 = "67"
rng.FormatConditions(1).SetFormula69 = "68"
rng.FormatConditions(1).SetFormula70 = "69"
rng.FormatConditions(1).SetFormula71 = "70"
rng.FormatConditions(1).SetFormula72 = "71"
rng.FormatConditions(1).SetFormula73 = "72"
rng.FormatConditions(1).SetFormula74 = "73"
rng.FormatConditions(1).SetFormula75 = "74"
rng.FormatConditions(1).SetFormula76 = "75"
rng.FormatConditions(1).SetFormula77 = "76"
rng.FormatConditions(1).SetFormula78 = "77"
rng.FormatConditions(1).SetFormula79 = "78"
rng.FormatConditions(1).SetFormula80 = "79"
rng.FormatConditions(1).SetFormula81 = "80"
rng.FormatConditions(1).SetFormula82 = "81"
rng.FormatConditions(1).SetFormula83 = "82"
rng.FormatConditions(1).SetFormula84 = "83"
rng.FormatConditions(1).SetFormula85 = "84"
rng.FormatConditions(1).SetFormula86 = "85"
rng.FormatConditions(1).SetFormula87 = "86"
rng.FormatConditions(1).SetFormula88 = "87"
rng.FormatConditions(1).SetFormula89 = "88"
rng.FormatConditions(1).SetFormula90 = "89"
rng.FormatConditions(1).SetFormula91 = "90"
rng.FormatConditions(1).SetFormula92 = "91"
rng.FormatConditions(1).SetFormula93 = "92"
rng.FormatConditions(1).SetFormula94 = "93"
rng.FormatConditions(1).SetFormula95 = "94"
rng.FormatConditions(1).SetFormula96 = "95"
rng.FormatConditions(1).SetFormula97 = "96"
rng.FormatConditions(1).SetFormula98 = "97"
rng.FormatConditions(1).SetFormula99 = "98"
rng.FormatConditions(1).SetFormula100 = "99"
rng.FormatConditions(1).SetFormula101 = "100"
rng.FormatConditions(1).SetFormula102 = "101"
rng.FormatConditions(1).SetFormula103 = "102"
rng.FormatConditions(1).SetFormula104 = "103"
rng.FormatConditions(1).SetFormula105 = "104"
rng.FormatConditions(1).SetFormula106 = "105"
rng.FormatConditions(1).SetFormula107 = "106"
rng.FormatConditions(1).SetFormula108 = "107"
rng.FormatConditions(1).SetFormula109 = "108"
rng.FormatConditions(1).SetFormula110 = "109"
rng.FormatConditions(1).SetFormula111 = "110"
rng.FormatConditions(1).SetFormula112 = "111"
rng.FormatConditions(1).SetFormula113 = "112"
rng.FormatConditions(1).SetFormula114 = "113"
rng.FormatConditions(1).SetFormula115 = "114"
rng.FormatConditions(1).SetFormula116 = "115"
rng.FormatConditions(1).SetFormula117 = "116"
rng.FormatConditions(1).SetFormula118 = "117"
rng.FormatConditions(1).SetFormula119 = "118"
rng.FormatConditions(1).SetFormula120 = "119"
rng.FormatConditions(1).SetFormula121 = "120"
rng.FormatConditions(1).SetFormula122 = "121"
rng.FormatConditions(1).SetFormula123 = "122"
rng.FormatConditions(1).SetFormula124 = "123"
rng.FormatConditions(1).SetFormula125 = "124"
rng.FormatConditions(1).SetFormula126 = "125"
rng.FormatConditions(1).SetFormula127 = "126"
rng.FormatConditions(1).SetFormula128 = "127"
rng.FormatConditions(1).SetFormula129 = "128"
rng.FormatConditions(1).SetFormula130 = "129"
rng.FormatConditions(1).SetFormula131 = "130"
rng.FormatConditions(1).SetFormula132 = "131"
rng.FormatConditions(1).SetFormula133 = "132"
rng.FormatConditions(1).SetFormula134 = "133"
rng.FormatConditions(1).SetFormula135 = "134"
rng.FormatConditions(1).SetFormula136 = "135"
rng.FormatConditions(1).SetFormula137 = "136"
rng.FormatConditions(1).SetFormula138 = "137"
rng.FormatConditions(1).SetFormula139 = "138"
rng.FormatConditions(1).SetFormula140 = "139"
rng.FormatConditions(1).SetFormula141 = "140"
rng.FormatConditions(1).SetFormula142 = "141"
rng.FormatConditions(1).SetFormula143 = "142"
rng.FormatConditions(1).SetFormula144 = "143"
rng.FormatConditions(1).SetFormula145 = "144"
rng.FormatConditions(1).SetFormula146 = "145"
rng.FormatConditions(1).SetFormula147 = "146"
rng.FormatConditions(1).SetFormula148 = "147"
rng.FormatConditions(1).SetFormula149 = "148"
rng.FormatConditions(1).SetFormula150 = "149"
rng.FormatConditions(1).SetFormula151 = "150"
rng.FormatConditions(1).SetFormula152 = "151"
rng.FormatConditions(1).SetFormula153 = "152"
rng.FormatConditions(1).SetFormula154 = "153"
rng.FormatConditions(1).SetFormula155 = "154"
rng.FormatConditions(1).SetFormula156 = "155"
rng.FormatConditions(1).SetFormula157 = "156"
rng.FormatConditions(1).SetFormula158 = "157"
rng.FormatConditions(1).SetFormula159 = "158"
rng.FormatConditions(1).SetFormula160 = "159"
rng.FormatConditions(1).SetFormula161 = "160"
rng.FormatConditions(1).SetFormula162 = "161"
rng.FormatConditions(1).SetFormula163 = "162"
rng.FormatConditions(1).SetFormula164 = "163"
rng.FormatConditions(1).SetFormula165 = "164"
rng.FormatConditions(1).SetFormula166 = "165"
rng.FormatConditions(1).SetFormula167 = "166"
rng.FormatConditions(1).SetFormula168 = "167"
rng.FormatConditions(1).SetFormula169 = "168"
rng.FormatConditions(1).SetFormula170 = "169"
rng.FormatConditions(1).SetFormula171 = "170"
rng.FormatConditions(1).SetFormula172 = "171"
rng.FormatConditions(1).SetFormula173 = "172"
rng.FormatConditions(1).SetFormula174 = "173"
rng.FormatConditions(1).SetFormula175 = "174"
rng.FormatConditions(1).SetFormula176 = "175"
rng.FormatConditions(1).SetFormula177 = "176"
rng.FormatConditions(1).SetFormula178 = "177"
rng.FormatConditions(1).SetFormula179 = "178"
rng.FormatConditions(1).SetFormula180 = "179"
rng.FormatConditions(1).SetFormula181 = "180"
rng.FormatConditions(1).SetFormula182 = "181"
rng.FormatConditions(1).SetFormula183 = "182"
rng.FormatConditions(1).SetFormula184 = "183"
rng.FormatConditions(1).SetFormula185 = "184"
rng.FormatConditions(1).SetFormula186 = "185"
rng.FormatConditions(1).SetFormula187 = "186"
rng.FormatConditions(1).SetFormula188 = "187"
rng.FormatConditions(1).SetFormula189 = "188"
rng.FormatConditions(1).SetFormula190 = "189"
rng.FormatConditions(1).SetFormula191 = "190"
rng.FormatConditions(1).SetFormula192 = "191"
rng.FormatConditions(1).SetFormula193 = "192"
rng.FormatConditions(1).SetFormula194 = "193"
rng.FormatConditions(1).SetFormula195 = "194"
rng.FormatConditions(1).SetFormula196 = "195"
rng.FormatConditions(1).SetFormula197 = "196"
rng.FormatConditions(1).SetFormula198 = "197"
rng.FormatConditions(1).SetFormula199 = "198"
rng.FormatConditions(1).SetFormula200 = "199"
rng.FormatConditions(1).SetFormula201 = "200"
rng.FormatConditions(1).SetFormula202 = "201"
rng.FormatConditions(1).SetFormula203 = "202"
rng.FormatConditions(1).SetFormula204 = "203"
rng.FormatConditions(1).SetFormula205 = "204"
rng.FormatConditions(1).SetFormula206 = "205"
rng.FormatConditions(1).SetFormula207 = "206"
rng.FormatConditions(1).SetFormula208 = "207"
rng.FormatConditions(1).SetFormula209 = "208"
rng.FormatConditions(1).SetFormula210 = "209"
rng.FormatConditions(1).SetFormula211 = "210"
rng.FormatConditions(1).SetFormula212 = "211"
rng.FormatConditions(1).SetFormula213 = "212"
rng.FormatConditions(1).SetFormula214 = "213"
rng.FormatConditions(1).SetFormula215 = "214"
rng.FormatConditions(1).SetFormula216 = "215"
rng.FormatConditions(1).SetFormula217 = "216"
rng.FormatConditions(1).SetFormula218 = "217"
rng.FormatConditions(1).SetFormula219 = "218"
rng.FormatConditions(1).SetFormula220 = "219"
rng.FormatConditions(1).SetFormula221 = "220"
rng.FormatConditions(1).SetFormula222 = "221"
rng.FormatConditions(1).SetFormula223 = "222"
rng.FormatConditions(1).SetFormula224 = "223"
rng.FormatConditions(1).SetFormula225 = "224"
rng.FormatConditions(1).SetFormula226 = "225"
rng.FormatConditions(1).SetFormula227 = "226"
rng.FormatConditions(1).SetFormula228 = "227"
rng.FormatConditions(1).SetFormula229 = "228"
rng.FormatConditions(1).SetFormula230 = "229"
rng.FormatConditions(1).SetFormula231 = "230"
rng.FormatConditions(1).SetFormula232 = "231"
rng.FormatConditions(1).SetFormula233 = "232"
rng.FormatConditions(1).SetFormula234 = "233"
rng.FormatConditions(1).SetFormula235 = "234"
rng.FormatConditions(1).SetFormula236 = "235"
rng.FormatConditions(1).SetFormula237 = "236"
rng.FormatConditions(1).SetFormula238 = "237"
rng.FormatConditions(1).SetFormula239 = "238"
rng.FormatConditions(1).SetFormula240 = "239"
rng.FormatConditions(1).SetFormula241 = "240"
rng.FormatConditions(1).SetFormula242 = "241"
rng.FormatConditions(1).SetFormula243 = "242"
rng.FormatConditions(1).SetFormula244 = "243"
rng.FormatConditions(1).SetFormula245 = "244"
rng.FormatConditions(1).SetFormula246 = "245"
rng.FormatConditions(1).SetFormula247 = "246"
rng.FormatConditions(1).SetFormula248 = "247"
rng.FormatConditions(1).SetFormula249 = "248"
rng.FormatConditions(1).SetFormula250 = "249"
rng.FormatConditions(1).SetFormula251 = "250"
rng.FormatConditions(1).SetFormula252 = "251"
rng.FormatConditions(1).SetFormula253 = "252"
rng.FormatConditions(1).SetFormula254 = "253"
rng.FormatConditions(1).SetFormula255 = "254"
rng.FormatConditions(1).SetFormula256 = "255"
rng.FormatConditions(1).SetFormula257 = "256"
rng.FormatConditions(1).SetFormula258 = "257"
rng.FormatConditions(1).SetFormula259 = "258"
rng.FormatConditions(1).SetFormula260 = "259"
rng.FormatConditions(1).SetFormula261 = "260"
rng.FormatConditions(1).SetFormula262 = "261"
rng.FormatConditions(1).SetFormula263 = "262"
rng.FormatConditions(1).SetFormula264 = "263"
rng.FormatConditions(1).SetFormula265 = "264"
rng.FormatConditions(1).SetFormula266 = "265"
rng.FormatConditions(1).SetFormula267 = "266"
rng.FormatConditions(1).SetFormula268 = "267"
rng.FormatConditions(1).SetFormula269 = "268"
rng.FormatConditions(1).SetFormula270 = "269"
rng.FormatConditions(1).SetFormula271 = "270"
rng.FormatConditions(1).SetFormula272 = "271"
rng.FormatConditions(1).SetFormula273 = "272"
rng.FormatConditions(1).SetFormula274 = "273"
rng.FormatConditions(1).SetFormula275 = "274"
rng.FormatConditions(1).SetFormula276 = "275"
rng.FormatConditions(1).SetFormula277 = "276"
rng.FormatConditions(1).SetFormula278 = "277"
rng.FormatConditions(1).SetFormula279 = "278"
rng.FormatConditions(1).SetFormula280 = "279"
rng.FormatConditions(1).SetFormula281 = "280"
rng.FormatConditions(1).SetFormula282 = "281"
rng.FormatConditions(1).SetFormula283 = "282"
rng.FormatConditions(1).SetFormula284 = "283"
rng.FormatConditions(1).SetFormula285 = "284"
rng.FormatConditions(1).SetFormula286 = "285"
rng.FormatConditions(1).SetFormula287 = "286"
rng.FormatConditions(1).SetFormula288 = "287"
rng.FormatConditions(1).SetFormula289 = "288"
rng.FormatConditions(1).SetFormula290 = "289"
rng.FormatConditions(1).SetFormula291 = "290"
rng.FormatConditions(1).SetFormula292 = "291"
rng.FormatConditions(1).SetFormula293 = "292"
rng.FormatConditions(1).SetFormula294 = "293"
rng.FormatConditions(1).SetFormula295 = "294"
rng.FormatConditions(1).SetFormula296 = "295"
rng.FormatConditions(1).SetFormula297 = "296"
rng.FormatConditions(1).SetFormula298 = "297"
rng.FormatConditions(1).SetFormula299 = "298"
rng.FormatConditions(1).SetFormula300 = "299"
rng.FormatConditions(1).SetFormula301 = "300"
rng.FormatConditions(1).SetFormula302 = "301"
rng.FormatConditions(1).SetFormula303 = "302"
rng.FormatConditions(1).SetFormula304 = "303"
rng.FormatConditions(1).SetFormula305 = "304"
rng.FormatConditions(1).SetFormula306 = "305"
rng.FormatConditions(1).SetFormula307 = "306"
rng.FormatConditions(1).SetFormula308 = "307"
rng.FormatConditions(1).SetFormula309 = "308"
rng.FormatConditions(1).SetFormula310 = "309"
rng.FormatConditions(1).SetFormula311 = "310"
rng.FormatConditions(1).SetFormula312 = "311"
rng.FormatConditions(1).SetFormula313 = "312"
rng.FormatConditions(1).SetFormula314 = "313"
rng.FormatConditions(1).SetFormula315 = "314"
rng.FormatConditions(1).SetFormula316 = "315"
rng.FormatConditions(1).SetFormula317 = "316"
rng.FormatConditions(1).SetFormula318 = "317"
rng.FormatConditions(1).SetFormula319 = "318"
rng.FormatConditions(1).SetFormula320 = "319"
rng.FormatConditions(1).SetFormula321 = "320"
rng.FormatConditions(1).SetFormula322 = "321"
rng.FormatConditions(1).SetFormula323 = "322"
rng.FormatConditions(1).SetFormula324 = "323"
rng.FormatConditions(1).SetFormula325 = "324"
rng.FormatConditions(1).SetFormula326 = "325"
rng.FormatConditions(1).SetFormula327 = "326"
rng.FormatConditions(1).SetFormula328 = "327"
rng.FormatConditions(1).SetFormula329 = "328"
rng.FormatConditions(1).SetFormula330 = "329"
rng.FormatConditions(1).SetFormula331 = "330"
rng.FormatConditions(1).SetFormula332 = "331"
rng.FormatConditions(1).SetFormula333 = "332"
rng.FormatConditions(1).SetFormula334 = "333"
rng.FormatConditions(1).SetFormula335 = "334"
rng.FormatConditions(1).SetFormula336 = "335"
rng.FormatConditions(1).SetFormula337 = "336"
rng.FormatConditions(1).SetFormula338 = "337"
rng.FormatConditions(1).SetFormula339 = "338"
rng.FormatConditions(1).SetFormula340 = "339"
rng.FormatConditions(1).SetFormula341 = "340"
rng.FormatConditions(1).SetFormula342 = "341"
rng.FormatConditions(1).SetFormula343 = "342"
rng.FormatConditions(1).SetFormula344 = "343"
rng.FormatConditions(1).SetFormula345 = "344"
rng.FormatConditions(1).SetFormula346 = "345"
rng.FormatConditions(1).SetFormula347 = "346"
rng.FormatConditions(1).SetFormula348 = "347"
rng.FormatConditions(1).SetFormula349 = "348"
rng.FormatConditions(1).SetFormula350 = "349"
rng.FormatConditions(1).SetFormula351 = "350"
rng.FormatConditions(1).SetFormula352 = "351"
rng.FormatConditions(1).SetFormula353 = "352"
rng.FormatConditions(1).SetFormula354 = "353"
rng.FormatConditions(1).SetFormula355 = "354"
rng.FormatConditions(1).SetFormula356 = "355"
rng.FormatConditions(1).SetFormula357 = "356"
rng.FormatConditions(1).SetFormula358 = "357"
rng.FormatConditions(1).SetFormula359 = "358"
rng.FormatConditions(1).SetFormula360 = "359"
rng.FormatConditions(1).SetFormula361 = "360"
rng.FormatConditions(1).SetFormula362 = "361"
rng.FormatConditions(1).SetFormula363 = "362"
rng.FormatConditions(1).SetFormula364 = "363"
rng.FormatConditions(1).SetFormula365 = "364"
rng.FormatConditions(1).SetFormula366 = "365"
rng.FormatConditions(1).SetFormula367 = "366"
rng.FormatConditions(1).SetFormula368 = "367"
rng.FormatConditions(1).SetFormula369 = "368"
rng.FormatConditions(1).SetFormula370 = "369"
rng.FormatConditions(1).SetFormula371 = "370"
rng.FormatConditions(1).SetFormula372 = "371"
rng.FormatConditions(1).SetFormula373 = "372"
rng.FormatConditions(1).SetFormula374 = "373"
rng.FormatConditions(1).SetFormula375 = "374"
rng.FormatConditions(1).SetFormula376 = "375"
rng.FormatConditions(1).SetFormula377 = "376"
rng.FormatConditions(1).SetFormula378 = "377"
rng.FormatConditions(1).SetFormula379 = "378"
rng.FormatConditions(1).SetFormula380 = "379"
rng.FormatConditions(1).SetFormula381 = "380"
rng.FormatConditions(1).SetFormula382 = "381"
rng.FormatConditions(1).SetFormula383 = "382"
rng.FormatConditions(1).SetFormula384 = "383"
rng.FormatConditions(1).SetFormula385 = "384"
rng.FormatConditions(1).SetFormula386 = "385"
rng.FormatConditions(1).SetFormula387 = "386"
rng.FormatConditions(1).SetFormula388 = "387"
rng.FormatConditions(1).SetFormula389 = "388"
rng.FormatConditions(1).SetFormula390 = "389"
rng.FormatConditions(1).SetFormula391 = "390"
rng.FormatConditions(1).SetFormula392 = "391"
rng.FormatConditions(1).SetFormula393 = "392"
rng.FormatConditions(1).SetFormula394 = "393"
rng.FormatConditions(1).SetFormula395 = "394"
rng.FormatConditions(1).SetFormula396 = "395"
rng.FormatConditions(1).SetFormula397 = "396"
rng.FormatConditions(1).SetFormula398 = "397"
rng.FormatConditions(1).SetFormula399 = "398"
rng.FormatConditions(1).SetFormula400 = "399"
rng.FormatConditions(1).SetFormula401 = "400"
rng.FormatConditions(1).SetFormula402 = "401"
rng.FormatConditions(1).SetFormula403 = "402"
rng.FormatConditions(1).SetFormula404 = "403"
rng.FormatConditions(1).SetFormula405 = "404"
rng.FormatConditions(1).SetFormula406 = "405"
rng.FormatConditions(1).SetFormula407 = "406"
rng.FormatConditions(1).SetFormula408 = "407"
rng.FormatConditions(1).SetFormula409 = "408"
rng.FormatConditions(1).SetFormula410 = "409"
rng.FormatConditions(1).SetFormula411 = "410"
rng.FormatConditions(1).SetFormula412 = "411"
rng.FormatConditions(1).SetFormula413 = "412"
rng.FormatConditions(1).SetFormula414 = "413"
rng.FormatConditions(1).SetFormula415 = "414"
rng.FormatConditions(1).SetFormula416 = "415"
rng.FormatConditions(1).SetFormula417 = "416"
rng.FormatConditions(1).SetFormula418 = "417"
rng.FormatConditions(1).SetFormula419 = "418"
rng.FormatConditions(1).SetFormula420 = "419"
rng.FormatConditions(1).SetFormula421 = "420"
rng.FormatConditions(1).SetFormula422 = "421"
rng.FormatConditions(1).SetFormula423 = "422"