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...