How do I change font color (to make it easier to see) in a case formula that changes background color?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Font color change in case formula Using following for background color change under certain values from a different field.  Because of background color need to make the font white to make it easier to read.  How?

Case([Status - Edit],"Tentative","<div style="background-color:grey;">Tentative</div>",                                "Scheduled","<div style="background color:black;">Scheduled</div>",                                            "Needs to be invoiced","<div style="background-color:red;">Needs to be invoiced</div>",              "Invoiced","<div style="background-color:green;">Invoiced</div>", "")


Photo of Apogeez


  • 0 Points

Posted 4 years ago

  • 0
  • 1
This seems to work

"<span style='background-color:yellow'>" & "<font color=blue>hello</span>"