I have a document and the cells contents are being generated by VBA code and they look simular to this.
21.00 MB
43.21 KB
123.4 GB
-323.2 MB
Etc etc. It's all file sizes though some can be negative.
What I am trying to do is to change that cells font color to red if it's negative and green if it's posotive. I am not too sure how to do this with VBA but I was also wondering if this is possible to do with Conditional Formatting?
I am aware of using LEFT and RIGHT to seperate the values when using IF, but I am not sure how this would be utilized in conditional formatting or if there's an easier VBA solution.
Thanks!
21.00 MB
43.21 KB
123.4 GB
-323.2 MB
Etc etc. It's all file sizes though some can be negative.
What I am trying to do is to change that cells font color to red if it's negative and green if it's posotive. I am not too sure how to do this with VBA but I was also wondering if this is possible to do with Conditional Formatting?
I am aware of using LEFT and RIGHT to seperate the values when using IF, but I am not sure how this would be utilized in conditional formatting or if there's an easier VBA solution.
Thanks!