I have a small list I'm testing in for traffic lights right now with 3 columns.
Title, column1 and traffic light
title is just a text column, column1 is a number column, and traffic light is a calculated column with a bit of HTML/CSS in it with the .
the code for traffic light looks like:
="<DIV style='font-weight:bold; font-size:24px; color:"&IF([column1]<6,"Green",IF([column1]>12,"Red","Yellow"))&";'>•</DIV>"
Right now its only working in part. I update column 1 with a number and it will return the line of code it should be not the color.
example: I enter 10 in column1 Traffic Lights return
:<DIV style='font-weight:bold; font-size:24px; color:Yellow;'>.</DIV>
This should just return a yellow dot. It will change depending on the number I enter but It's not showing the color.
Is there a setting or feature I need to turn on?