Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 years ago

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

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 d...
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

If(

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

}