1044
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

Please add ASAP!

D

Agreed, the FORMAT function needs the ability to format text by all the standard text formatting options including, color, bold/italic, strike-through, underline, etc...

D

It is needed .

Thanks

D

Would be helpful when you have a measure coded and then you can set the visual output text to change color as needed - similar to this text box. Please push through...

D

This is an awesome idea! I'm facing some hurdles right now that will be solved by this feature if available.

D

Good idea!

D

This would be amazing! Please.

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!