Conditional Formatting (Macro)

[Magy_22]

Hello Excel Experts!!
I am new in the VBA world, and I have an issue I hope you can help me solve.
When I have a set of data, and I set a conditional format to all this data, but there is one item that doesn’t apply, we must make it the opposite ). Can I have code do it? For a particular item every time?

Example:
Revenues:
if the number > 0 make the font color green and if the number <0 make it red

Expenses:
if the number > 0 make the font color red and if the number <0 make it green

GOP:
if the number > 0 make the font color green and if the number <0 make it red


I really appreciate any help you can provide.

 

[BSALV]

why do you want to do it in VBA.
That can be done with the normal formulas, isn't it ?