Spreadsheet: 702996d1604663129-conditional-formatting-include-a-line-to-show-border-between-positive-and-negative-numbers-example-excelforum
Sheet: Sheet1

 |  | Table1
 |  | 1275.2452208 | 1136.3018384 | 997.358456 | 858.4150735999998 | 719.4716912 | 580.5283088000002 | 441.5849264 | 302.6415440000002 | 163.6981616000002 | 24.75477920000022 | -114.1886032000002
 |  | 1288.7452208 | 1146.8018384 | 1004.858456 | 862.9150735999998 | 720.9716912 | 579.0283088000002 | 437.0849264 | 295.1415440000002 | 153.1981616000002 | 11.25477920000022 | -130.6886032000002 | I would like to include a line with conditional formatting to shwo where the border is between a plus and min number
 |  | 1302.2452208 | 1157.3018384 | 1012.358456 | 867.4150735999998 | 722.4716912 | 577.5283088000002 | 432.5849264 | 287.6415440000002 | 142.6981616000002 | -2.245220799999777 | -147.1886032000002 | Please also  see table 2 where I manually insert a black line to show the border between a plus and a minus number
 |  | 1315.7452208 | 1167.8018384 | 1019.858456 | 871.9150735999998 | 723.9716912 | 576.0283088000002 | 428.0849264 | 280.1415440000002 | 132.1981615999998 | -15.74522079999978 | -163.6886032000002
 |  | 1329.2452208 | 1178.3018384 | 1027.358456 | 876.4150735999998 | 725.4716912 | 574.5283088000002 | 423.5849264 | 272.6415440000002 | 121.6981616000002 | -29.24522079999978 | -180.1886032000002
 |  | 1342.7452208 | 1188.8018384 | 1034.858456 | 880.9150735999998 | 726.9716912 | 573.0283088000002 | 419.0849264 | 265.1415440000002 | 111.1981616000002 | -42.74522079999978 | -196.6886032000002
 |  | 1356.2452208 | 1199.3018384 | 1042.358456 | 885.4150735999998 | 728.4716912 | 571.5283088000002 | 414.5849264 | 257.6415440000002 | 100.6981616000002 | -56.24522079999978 | -213.1886031999998
 |  | 1369.7452208 | 1209.8018384 | 1049.858456 | 889.9150735999998 | 729.9716912 | 570.0283088000002 | 410.0849264 | 250.1415440000002 | 90.19816160000022 | -69.74522079999977 | -229.6886032000002
 |  | 1383.2452208 | 1220.3018384 | 1057.358456 | 894.4150735999998 | 731.4716912 | 568.5283088000002 | 405.5849264 | 242.6415440000002 | 79.69816159999976 | -83.24522079999977 | -246.1886031999998
 |  | 1396.7452208 | 1230.8018384 | 1064.858456 | 898.9150735999998 | 732.9716912 | 567.0283088000002 | 401.0849264 | 235.1415440000002 | 69.19816159999976 | -96.74522079999977 | -262.6886032000003
 |  | 1410.2452208 | 1241.3018384 | 1072.358456 | 903.4150735999998 | 734.4716912 | 565.5283088000002 | 396.5849264 | 227.6415440000002 | 58.69816160000023 | -110.2452207999998 | -279.1886031999998
 |  | 1423.7452208 | 1251.8018384 | 1079.858456 | 907.9150735999998 | 735.9716912 | 564.0283088000002 | 392.0849264 | 220.1415440000002 | 48.19816160000023 | -123.7452207999998 | -295.6886031999998
 |  | 1437.2452208 | 1262.3018384 | 1087.358456 | 912.4150735999998 | 737.4716912 | 562.5283088000002 | 387.5849264 | 212.6415440000002 | 37.69816160000023 | -137.2452207999998 | -312.1886031999998
 |  | 1450.7452208 | 1272.8018384 | 1094.858456 | 916.9150735999998 | 738.9716912 | 561.0283088000002 | 383.0849264 | 205.1415440000002 | 27.19816160000023 | -150.7452207999998 | -328.6886031999998
 |  | 1464.2452208 | 1283.3018384 | 1102.358456 | 921.4150735999998 | 740.4716912 | 559.5283088000002 | 378.5849264 | 197.6415440000002 | 16.69816160000023 | -164.2452207999998 | -345.1886031999998
 |  | Table2
 |  | 1275.2452208 | 1136.3018384 | 997.358456 | 858.4150735999998 | 719.4716912 | 580.5283088000002 | 441.5849264 | 302.6415440000002 | 163.6981616000002 | 24.75477920000022 | -114.1886032000002
 |  | 1288.7452208 | 1146.8018384 | 1004.858456 | 862.9150735999998 | 720.9716912 | 579.0283088000002 | 437.0849264 | 295.1415440000002 | 153.1981616000002 | 11.25477920000022 | -130.6886032000002
 |  | 1302.2452208 | 1157.3018384 | 1012.358456 | 867.4150735999998 | 722.4716912 | 577.5283088000002 | 432.5849264 | 287.6415440000002 | 142.6981616000002 | -2.245220799999777 | -147.1886032000002
 |  | 1315.7452208 | 1167.8018384 | 1019.858456 | 871.9150735999998 | 723.9716912 | 576.0283088000002 | 428.0849264 | 280.1415440000002 | 132.1981615999998 | -15.74522079999978 | -163.6886032000002
 |  | 1329.2452208 | 1178.3018384 | 1027.358456 | 876.4150735999998 | 725.4716912 | 574.5283088000002 | 423.5849264 | 272.6415440000002 | 121.6981616000002 | -29.24522079999978 | -180.1886032000002
 |  | 1342.7452208 | 1188.8018384 | 1034.858456 | 880.9150735999998 | 726.9716912 | 573.0283088000002 | 419.0849264 | 265.1415440000002 | 111.1981616000002 | -42.74522079999978 | -196.6886032000002
 |  | 1356.2452208 | 1199.3018384 | 1042.358456 | 885.4150735999998 | 728.4716912 | 571.5283088000002 | 414.5849264 | 257.6415440000002 | 100.6981616000002 | -56.24522079999978 | -213.1886031999998
 |  | 1369.7452208 | 1209.8018384 | 1049.858456 | 889.9150735999998 | 729.9716912 | 570.0283088000002 | 410.0849264 | 250.1415440000002 | 90.19816160000022 | -69.74522079999977 | -229.6886032000002
 |  | 1383.2452208 | 1220.3018384 | 1057.358456 | 894.4150735999998 | 731.4716912 | 568.5283088000002 | 405.5849264 | 242.6415440000002 | 79.69816159999976 | -83.24522079999977 | -246.1886031999998
 |  | 1396.7452208 | 1230.8018384 | 1064.858456 | 898.9150735999998 | 732.9716912 | 567.0283088000002 | 401.0849264 | 235.1415440000002 | 69.19816159999976 | -96.74522079999977 | -262.6886032000003
 |  | 1410.2452208 | 1241.3018384 | 1072.358456 | 903.4150735999998 | 734.4716912 | 565.5283088000002 | 396.5849264 | 227.6415440000002 | 58.69816160000023 | -110.2452207999998 | -279.1886031999998
 |  | 1423.7452208 | 1251.8018384 | 1079.858456 | 907.9150735999998 | 735.9716912 | 564.0283088000002 | 392.0849264 | 220.1415440000002 | 48.19816160000023 | -123.7452207999998 | -295.6886031999998
 |  | 1437.2452208 | 1262.3018384 | 1087.358456 | 912.4150735999998 | 737.4716912 | 562.5283088000002 | 387.5849264 | 212.6415440000002 | 37.69816160000023 | -137.2452207999998 | -312.1886031999998
 |  | 1450.7452208 | 1272.8018384 | 1094.858456 | 916.9150735999998 | 738.9716912 | 561.0283088000002 | 383.0849264 | 205.1415440000002 | 27.19816160000023 | -150.7452207999998 | -328.6886031999998
 |  | 1464.2452208 | 1283.3018384 | 1102.358456 | 921.4150735999998 | 740.4716912 | 559.5283088000002 | 378.5849264 | 197.6415440000002 | 16.69816160000023 | -164.2452207999998 | -345.1886031999998