Hi TBM comm,

I'm sure this has been covered before, but was curious if there was a way of adding conditional formatting to a specific column in a table or the value being referenced in that column? i.e. if the value is greater than 0% font = green, below 0% red etc. 

Thanks in advance,

Mike 

Hi Mike,

You need to add in a formula column;

Enter the formula to equal your value column and set the format as follows;

 =NumberFormat({$_},"<font color='green'>#,###.00;<font color='red'>-#,###.00")

Further information can be found at NumberFormat function 

Let me know how you go.

Hi Mike,

There is an additional way to do this as well by using the highlight feature within the tool. You would select the column the in the top ribbon select highlight. You can then fill in your constraints and it will highlight the cells in the specific colors.

Here is a thread on the feature:How to use Data Tab Highlight feature? 

Thanks,

Lauren Griessel

Hi @Lauren Griessel,

That's much cleaner but I thought that highlight changed the background not the font? is there a way to use that feature to change the font colour?

Thanks to both of you for assisting with this. Will try both methods and see which gives me the desired results. 

And Paul it has been too long mate. Good to hear from you!