Hi,
I am trying to format a cell with 2 types of formatting conditions that will display correctly on a chart. For instance if the cell is below 1000 I want it to use the standard number formatting, but if the cell is between 1000 -10000 I need it to look like 2.5k and for anything over 10000 I want it to display with the custom formatting of [<999950]$0,"k";[<999950000]$0,,"m";$0.0,,,"b". I have 4 charts with numbers ranging from 420 to 3.6b. I have tried using the conditional formatting but it will change the formatting in the cell but not on the chart. Any ideas please!
Thanks
Ang
I am trying to format a cell with 2 types of formatting conditions that will display correctly on a chart. For instance if the cell is below 1000 I want it to use the standard number formatting, but if the cell is between 1000 -10000 I need it to look like 2.5k and for anything over 10000 I want it to display with the custom formatting of [<999950]$0,"k";[<999950000]$0,,"m";$0.0,,,"b". I have 4 charts with numbers ranging from 420 to 3.6b. I have tried using the conditional formatting but it will change the formatting in the cell but not on the chart. Any ideas please!
Thanks
Ang
