Forum Discussion
bm_data
4 years agoFrequent Visitor
Conditional formatting cards based upon calculated values
I am creating a corporate metrics score card and need help with conditional formatting. I am using cards for all my values since I am combining so many sources in this one report, a table cannot be u...
- 4 years ago
Create this measure with your measure names
YTD RAG =
IF([YTD measure] >= [YTD Goal measure],"green","red")
TheN click on the YTD card / Format / General / Effects / BackgrouNd on / BackgrouNd Colour fx / Format style = Field value/ What field should this be based on = YTD RAG
Thanks for reaching out for help.
I have helped you, now please help me by giving kudos.
Remeber we are unpaid volunteers.
Click the thumbs up and accept as solution button.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
bm_data
4 years agoFrequent Visitor
speedramps Thank you for the reply, this is exactly what I was looking for.