Forum Discussion
Solved
Adding traffic lights to indicate "Status"
Hi, lookign for soem advice regarding adding traffic lights to indicate status, i.e. red ="Overdue", Amber = "Due Soon" and Green = "In Progress". Table uploaded is below. Many thanks in adva...
try this:
pls see the attachment below
ryan_mayu
Super User
Super UserLooking at the condtional formatting text but cannto get it to work. Tried to enter the measure
StatusColour = SWITCH(('Sheet3'[Task Due Status],"Overdue", "Red", "Due Soon", "Amber", "In Progress", "Green"))though the Task Due Status isnt being recognised.- ryan_mayu
try this:
pls see the attachment below
