Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell text length conditional formatting - Excel 2003 Manc Shaun Excel Discussion (Misc queries) 3 March 26th 09 11:58 AM
Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times [email protected] Excel Discussion (Misc queries) 2 September 6th 08 05:50 PM
How can I set conditional formatting in Excel for text sentences? David Excel Discussion (Misc queries) 3 February 6th 07 12:23 PM
Conditional Formatting based on text within a cell w/ text AND num Shirley Excel Worksheet Functions 2 December 22nd 06 01:40 AM
Conditional Formatting based on Text within Text George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"