Share via

Custom Formatting Question

Anonymous
2019-07-05T21:51:06+00:00

I am currently using this custom format to quickly show trending up or down:

[Green]▼0.00%;[Red]▲0.00%

Is there a way I could keep the arrows turning green or red but have the values/percentages stay black?

I can't figure it out.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-07-06T23:43:41+00:00

To:  Crothu,

Re:  custom cell format

Following may not be practical, but...

Uses two columns:

Column C is formatted as:  [Green]▼;[Red]▲;0;@

Column C contains your data.

Column D is formatted as Percentage

Column D cells are equal to Column C cells;   D2 is:  =C2

'---

Excel workbooks and add-ins at MediaFire

Download your choice: 

http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-07-08T22:53:35+00:00

    Hi Crothu,

    I am writing to follow up on this case. Did you check above replies? Please update us when you have time.

    Regards,

    Neha

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-07-06T05:38:12+00:00

    Can you provide below information to check

    1.  Initial Data

    2.  How are you applying above format.

    1. How arrows should change based on data.

    Detailed Screenshots would help to better understand your requirements.

    Was this answer helpful?

    0 comments