CSV file population from cell color format

[qwertydude]

Hi guys,

I have another question for the Excel experts.

Every few weeks, we get a calendar similar to the below via email. In case anyone's interested, it outlines non-trading days in certain countries.

<TABLE style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; FONT: 13px arial, sans-serif; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(34,34,34); WORD-SPACING: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" border=1><TBODY><TR><TH bgColor=#cc9933 colSpan=15>
March</TH><TH bgColor=#00ffff colSpan=13>April</TH></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#cc9933>COUNTRY</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">M</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">W</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">F</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">M</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">W</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">F</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">M</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">W</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">F</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>S</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">M</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">W</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">T</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">F</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Philippines</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Singapore</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Malaysia</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Japan</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Taiwan</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">China</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Indonesia</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Australia</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">India</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Korea</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Hong Kong</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">Thailand</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>13</TD></TR><TR><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">New Zealand</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>17</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>18</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">19</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">20</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">21</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">22</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">23</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>24</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>25</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">26</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">27</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">28</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">29</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">30</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>31</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>01</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">02</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">03</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">04</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ffff00>05</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>06</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>07</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#c0c0c0>08</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif" bgColor=#ff0000>09</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">10</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">11</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">12</TD><TD style="MARGIN: 0px; FONT-FAMILY: arial, sans-serif">13</TD></TR></TBODY></TABLE>

I want this in my calendar (Google.) The easiest way would be to find an equivalent calendar in Google, but I couldn't find one. So instead, I'd like to import this data into my calendar (Google) - rather than continually referring to the email/printout. I've done a bit of research but am running into some headwinds - so some guidance or tips to do this a better way would be great.

To import into Google calendar (or most calendars), a CSV with the following fields needs to be generated:
<TABLE style="WIDTH: 624pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=832><COLGROUP><COL style="WIDTH: 48pt" span=13 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=64>Subject</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Start Date</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Start Time</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>End Date</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>End Time</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>All Day Event</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Reminder On/Off</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Reminder Date</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Reminder Time</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Meeting Organizer</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Description</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Location</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>Private</TD></TR></TBODY></TABLE>

My main issue is with Subject and Start Date - rest of the fields are easily populated by IF statements.

So the general steps I believe are:
- Read color value of cell background
- if color value of cell background = 3 (red) or 6 (yellow), then
- use vlookup to find country, and populate column A in CSV with "country, Non-trading Day" or "country, half-trading day" respectively
- populate the date field (I'm a bit stuck here too, given the way the calendar is presented, particularly how to automate the month and year)
- make all cells just their values (removes if statements from the other cells)
- Remove any duplicates (we get sent these calendars every few weeks, and there are often overlaps between them)
- Save as CSV, import into Google calendar

I'm currently using a UDF to return the value of the cell background color, and then using if statements to compare the values, but then getting a bit stuck in populating the CSV fields. Any tips, or is there a much easier way to do this?

If multiple countries are not-trading on the same day, I'm still undecided whether to create one event per country (which I think would be easier to do), or create one event with the countries listed in the subject. I'm not very sure how to do the latter though.

Thanks in advance for any pointers.

 

[qwertydude]

Any ideas?

Let's make it a bit simpler for the moment - Let's say I have a field where I specify the month (say April) and then copy only the cells referring to April.

I can then do this later for May, etc.

Does that simply things greatly? It would mean we could define the month and prevent duplicates, but I'm still not entirely sure how to go about this. Ideas?

Thanks.

 

[qwertydude]

OK, after a bit more work, with the simplication above, I think I've figured most of it out now.

But I need help with a specific part. I currently have a UDF (thanks to the web) that returns the colour of the cell as a numeric value. In normal formula usage, you type "=colorindexofonecell(A1,FALSE,0)" and it returns a numeric value for the cell's fill-in colour.

I have a row incrementer and a column incrementer, with variables called "row" and "column" respectively. I've having a little bit of trouble working it into the formula - I think I might be doing it the wrong way.

I currently have:
If colorindexofoncell(RiCj,FALSE,0)=3

Basically, I want Excel to call on the UDF to check if the numeric value for the background colour on the current cell it is checking is 3, and if it is, then execute the following lines. If not, continue to go through the rest of the cells. i and j are the row and column incrementers respectively.

I am getting a ByRef Argument Type Mismatch error - while googling came up with many helpful results, I'm not quite understanding what to do about it. Help would be much appreciated. Thanks.

 

[qwertydude]

Never mind! I got it all working, albeit messily!

I ended up using some idle cells and using formula. The bit I was stuck on was my inexperience with using formula in VBA - you need to treat it as a text string completely, so rather than putting i and j, you need to put "=function(R" & i & "C" & j & ")" as an example, rather than what I had.

Many thanks for all the help!

 

[qwertydude]

OK, I got it working, but I guess I still have a question:

How do you use a function output in an if statement in VBA?

e.g. If SUM(A1:A5)=100, then
etc. etc.
else
etc. etc

Not really sure of the right search terms...probably something really basic but I can't quite figure it out. Thanks.