Conditional Formatting- Text with Multiple Colors?

[pmpkinspice97]

Is there a way to set up conditional formatting to make a text multiple colors?
Below is an example of my current conditional formatting setup. I have it set up to make the text and arrow red if the volume decreased and green if increased.

20 21↑ 19↓ 20↑

What I am wanting to do is make it so the number stays black, but the arrows are colored.

20 21↑ 19↓ 20↑

Is this possible?

 

[maxpit]

Hi pmpkinspice97,

you can use Conditional Formatting.

I assume that you entered the first 20 in B10 then you will need to apply the following 2 FCs for the C10:E10 range:

FC type -> uses a formula to determine which cells to format
Format -> Char Bold and green or red

Try it and let us know.

Bye

 

[zero269]

Is there a way to set up conditional formatting to make a text multiple colors?
Below is an example of my current conditional formatting setup. I have it set up to make the text and arrow red if the volume decreased and green if increased.

20 21↑ 19↓ 20↑

What I am wanting to do is make it so the number stays black, but the arrows are colored.

20 21↑ 19↓ 20↑

Is this possible?

Take a look at the Icon Sets. They have arrows with colors and it doesn't change the color of the cell values.
This site has some examples to check out how they work.

Excel Icon Sets conditional formatting: inbuilt and custom

See how to efficiently use built-in conditional formatting icon sets in Excel and create a custom icon set to compare two columns, based on another cell value, and more.

www.ablebits.com

 

[zero269]

One thing to note is:

Source: Redirecting
This is also the behavior I'm seeing when testing your four numerical values.
However, it might be possible to use a formula... within the Icon Sets settings, but I'm not entirely sure what formulas it will accept.

 

[zero269]

I tried playing around with a few options, but I can't get the Icon Sets to work 100%.

VBA Testing.xlsm
	AC	AD	AE	AF
13	20	21	19	20
14	25	25	24	28
15	30	19	26	31
16	35	36	35	34
Count

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AD13:AF16	Cell Value	>OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)	text	NO
AD13:AF16	Cell Value	=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)	text	NO
AD13:AF16	Cell Value	<OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)	text	NO
AD13:AF16	Other Type	Icon set		NO

I applied CFR to highlight cells to compare if cells get the correct arrows.
I was practicing with the following formula to check if the cell value to the left was higher, lower or the same.
Some are good, but not all...
It returns the value of the cell to the left, so I tried that in the Icon Sets options.

=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)

 

[Micron]

If you don't arrive at a solution, I'm thinking that vba may be able to do this based on the arrow character ascii value. It would be a bit of a challenge if it would work. Not so much to colour the character, but to first determine if the prior value is greater or less than the new value, then apply the formatting accordingly.

 

[Peter_SSs]

Below is an example of my current conditional formatting setup.

Can you detail exactly how you have set that up?