949
Extend Format Function to allow color in format code like in Excel. This would allow far more expressive conditional formatting in formulas. Take it a step further and add codes for bolding, italics and other formatting types. This would allow full flexibility in formatting of reports such as bolding certain rows, etc. Simple change - HUGE benefits! The finance community will thank you greatly!

EXAMPLE:

=FORMAT(1, "[[RED]] #") //formats number as red
=FORMAT(1, "[[#ff0000]] #") //formats number as red (using hex code)
=FORMAT(1, "[[RED;BOLD]] #") //formats number as red and bolds

STATUS DETAILS
Needs Votes

Comments

D

Come on this is not a big deal to add, please consider implementing this immediately...

D

This would make users lives a lot simpler. Please implement this. This has been languishing since September 2017 with my vote sits on 877??? Please implement this immediately.

D

This would make so many users' lives a lot simpler. Please implement this!

D

Please enable this function that allows part of a text string to be bold or italic.

D

and also formating Bold and Italic

D

Please make this happen!

D

This is needed please...

D

this has been languishing since September 2017 and with my vote sits on 801

How many more are needed for it to be considered!!.

This will make automation of standard reports so much easier where only certain values in a sentence needs to change each time the report is run, it would make creation of standardised reports (employee/supplier/product reviews etc..) simple to produce at the click of a slicer without having to make multiple edits and once the spelling is checked on the final version, all versions will be consistent

D

would be great to have this!

D

Still needed - please!