Sunday, April 22, 2018

SharePoint - KPI Traffic Light - RAG Indicator

Copy and Paste Below


="<DIV style='font-weight:bold; font-size:24px; font-size:24px; color:"&CHOOSE(LEFT(Status,1),"Green","Red","yellow")&";'>•</DIV>"


To Center Align the contents use below


="<DIV style='font-weight:bold; font-size:24px; font-size:24px;text-align: center; color:"&CHOOSE(LEFT(Status,1),"Green","Red","yellow")&";'>•</DIV>"

1 comment:

  1. Hi, I cannot get this to work in the current SP. I saw a lot of comments in the video with the same problem. Is there another step that we need to take in the newer version of SP?

    ReplyDelete