Forum Discussion
How to - Conditional Formatting - Percentage
Hi Everyone, First time posting so go easy on me. I am looking for a way to achieve the below result that Columns A+B+C+D=E But if Column E is greater than 80% of Column F, it will be for...
Thanks lbendlin
Could i trouble you to walk me through that.
For example when i try to set up the conditional formatting, it doesnt let me put in any formula so to speak.
lbendlin - in a bit more relevance to my data set. Am i creating a new measure with something like the below examples?
bgcolor = if('ALL COLUMNS'[Totals Billed and Unbilled] >= ('ALL COLUMNS'[Overall Limit] *.8,"Red")
=IF(('All Columns'[Overall Limit])>('All Columns'[Totals Billed and Unbilled])*80%,"greater","less")