Conditional Format Font Colour and Change Format of Value

Hello Anonymous ,

Please check FORMAT Function. It returns Text. So your number becomes a text and text measures cannot be conditionally formatted.

You should create a numeric variance measure:

Variance =[RF Day] - [Budget Day] It is numeric.

After that, select the variance measure from the data pane and a new pane will open up at the top. You will see format. Enter that #,0;(#,0);0 in there.

Now you can apply conditional font color, if value <0 Red etc.

If this solved your issue, please mark it as the accepted solution. ✅