Forum Discussion

STEPHANIEMILBU2's avatar
STEPHANIEMILBU2
Qrew Cadet
8 years ago

Highlight a field in a report

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?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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