richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 71
- Office Version
- 2016
- Platform
- Windows
I heard that VBA / Macro could help me with color coding a range of cells based on adding a character to another cell.
In this case I am trying to clear an amount from a balance sheet.
If I add a C to clear the item I need the three cells to the left of the amount to color code yellow.
Can this be done and what would this macro look like?
<colgroup><col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2446;">
<col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3072;">
<col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3669;">
<col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2218;">
<col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2019;" span="2">
<tbody>
</tbody>
In this case I am trying to clear an amount from a balance sheet.
If I add a C to clear the item I need the three cells to the left of the amount to color code yellow.
Can this be done and what would this macro look like?
Date | Loan Number | Customer Name | Amount | ||
5/19/2019 | 12345 | Smith | $744.93 | C | |
5/19/2019 | 3456 | Jones | $ 784.89 | | |
5/19/2019 | 6789 | Johnson | $ 333.43 |