Have a report exporting to excel. I use the NumberFormat line to change the font color if the number is a positive number. I'd like to change the interior color of the same cell. So in the end, if the number is a positive, the number should be red and the cell yellow.
Code:** Used for font color, this works fine .Columns("AG").NumberFormat = "[RED]###;-###;0" ** What I'm trying for the interior color that does not work .Columns("AG").Interior.Color = "[YELLOW]###;-###;0"