I’m trying to use VBA to apply conditional formatting to some cells in Excel. I want to change the font color, interior cell fill color, and also the borders based on a formula condition.