Magy_
03-29-2022, 02:47 PM
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.
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.