How can you create a text formula field to look at a date field and color the font and background

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have two date fields, one is Delivery Date and the other is Delayed Delivery. I also have a text formula field that I want to color the background on. The text formula field would simply look at a date entered in the Delayed Delivery date field and color the background yellow and the font red.

This is what I have but it is not picking up anything.

If(
[Delayed Delivery]<>[Delivery Date],"<div style=\"background-color:yellow;\"><b><font color = red>")
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

If(

[Delayed delivery]<>[Delivery Date],"<div style='background-color:yellow;'"&[delayed delivery]&"</div>",""

}

(Edited)