Interior.Color question

[Johnny12]

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.

** 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"

[JoeM]

You cannot put a number format condition in the ".Interior.Color" property. It doesn't make sense, and is not allowed.
A different way to approach that part is to put Conditional Formatting on that column, to set the yello Interior Color property.

[Johnny12]

Thank you. Considered this solved.

[JoeM]

You are welcome.