I'm looking to create a rountine, possibly with RegEX. I want to look at a string, and if it is has a - (minus sign) in it highlight it in red, if not, display it as green.
Is there a function like is_negative() or will i need RegEX to search for it in the string and then do my conditional formatting if found?
I might possibly want to remove the - and then reformat the string so that i can move the - to the outside of the string... as it's a formatted currency. currently it negative numbers look like this : $-1.00
thanks all~!