Forum Discussion
Anonymous
6 years agoNot applicable
Target Met conditional formatting
If target <=Actual then Actual value show show in Green font/ background color else Red Thanks.
- 6 years ago
Hi Anonymous,
Create a Measure that returns the Hex Code you want to apply to your Back/Font Color, then use the Field Value option when setting up conditional formatting
back color = if([target]<=[actual], "#008000", "#FF0000")Hope this helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
richbenmintz
6 years agoResident Rockstar
Hi Anonymous,
You would use the conditional value by value option
Anonymous
6 years agoNot applicable