TEXT values are not recognized - defaulting to "General" and cannot be updated without adding FORMAT

[ashleyfiore]

TEXT values are not recognized - defaulting to "General" and cannot be updated without adding FORMAT([Measure], "TEXT") to the measure sintax. 

This is causing all conditional fomrating based on hex values to be uneditable. 

[Anonymous]

Hi @ashleyfiore ,

If you would like to suggest  feature improvements, you may  vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Caitlyn