Two colours in a single based on positive or negative value

[montu_seshil]

Hi folks,
need some expertise to handle a cell that has both positive/negative values and colour the portion of it.

attached is an example.

so, a Cell has a string and number, I want the colour green if it is increased and red if decreased. I am doing it manually and it takes ages. any suggestions or ideas on how to handle this ?

thanks

 

[Roe_01]

Hi Montu -
I can share how I was able to get my excel datasheet to reflect an increase or decrease based on input. I noticed you have the increase or decrease % within one cell so I don't know how to solve for that item. I normally merge some cells (i.e. text) to make it easy for me to use various formulas.

Below are some screen shots and hope it helps. Good luck.

**Custom Format to add % and arrows**
[Color10]0%"▲";[Red]-0%"▼";

Here is my mockup of the example you provided. I removed the gridlines on the sheet and just add borders. I divided 2.20 / 3.37 to get a positive value and 3.37 / 2.20*-1 to get negative value in order to demonstrate the output.

 

[montu_seshil]

thank you