Len Lanetti
Cleared for Takeoff
This is an accounting meets marketing type of question.
Is there a way to write a formula or perhaps another formating based method that will change the text color for a value based on the value?
What I want to do is have a result appear as red for a negative number and green for a positive number.
I'm using Excel as the spreadsheet.
Thanks,
Len
Is there a way to write a formula or perhaps another formating based method that will change the text color for a value based on the value?
What I want to do is have a result appear as red for a negative number and green for a positive number.
I'm using Excel as the spreadsheet.
Thanks,
Len