Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell text length conditional formatting - Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 Conditional formatting - change text colour when enteringsame name more than 3 times | Excel Discussion (Misc queries) | |||
How can I set conditional formatting in Excel for text sentences? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) |