Forum Discussion
Cornwalls
Helper I
Helper IHow 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...
lbendlin
Super User
Super UserYou can do conditional formatting based on the value of a field - and that can be a field that isn't even on the visual.
bgcolor = if(A+B+C+D >= F*.8,"Red")