View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bwilde@gmail.com is offline
external usenet poster
 
Posts: 9
Default Excel Text Conditional Formatting

Hello,

I would like to change the color of some text based on conditions. Of
course, it's not quite as simple as it could be. My data is contained
in one column, but consists of one set of data, concatenated with some
parentheses and another set of data.

So, my data looks like this:
100 (30)
200 (-10)
300 (-20)

What I would like would be for the number in parentheses to be green
if it's positive and red if it's negative. Is there a way to do this?

Thanks,
Ben