Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Text Color 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Text Color Conditional Formatting
As i am aware not ONLY the values in the Brackets.
You can formatCellsNumber and Select the RED Negative Numbers. But this will apply to the entire cell. Corey.... wrote in message oups.com... 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 | |||
conditional formatting text warning and color change | Excel Worksheet Functions | |||
check text color from conditional formatting w/out using VB | Excel Discussion (Misc queries) | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
change color of text in cell without conditional formatting | Excel Discussion (Misc queries) | |||
Changing text color usinf a formula (NOT Conditional Formatting) | Excel Discussion (Misc queries) |