want to have my field change color based on an answer

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

I have a field that I would like to turn the background RED if a date is within a range.

If [Start Date] and [End Date] is within the current range change this text formula field[ DATE DISPLAY ] to RED and display this message 'TPR Title"

So if the start date is 10/1/15 and the end date is 10/31/15 and today is 10/20/15 then I want Date Display to have a red background with the text TPR title.

Once the start and end dates are out of that range (Nov. 1st) then the display goes back to blank

Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Cecelia

Cecelia

  • 160 Points 100 badge 2x thumb
I actually figured this out!



If
(Today()>=[TPR: Start Date] and Today()<=[TPR: End Date], "<div style=\"background-color:#FF3333;\"> <b>TPR TITLE</b></div>","")