Highlight a field in a report

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I need to Highlight {Construction Start Date} field in a report in RED if it is before [Anticipated Delivery Date] or Highlight the field in Yellow if the dates are the same.  how do I do this? Help please?
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
In the "Customize This Report" settings you can add colorization to the row if the criteria is met.

Your formula would look something like this:

If([Construction Start Date]<[Anticipated Delivery Date], "red", 
If([Construction Start Date]=[Anticipated Delivery Date], "yellow", ""))

You can replace "red" with some color hex if you want to be more precise with the colors
"#565656", etc