Color Coding Blank Dates
Hello. I don't know if this is possible but I have tried several formulas to no avail. I am trying to assign a color to show if a field has a blank date in a report. like this: ----------...
Forum Discussion
Hello,
I need further assistance with this, please. I would like the [MUD DELIVERY] field to be colorized if there is no date in the field.
This is the formula I have used, but it seems to be doing nothing.
[HIGHLIGHT FIELD] - Rich text formula:
If(IsNull([MUD DELIVERY]), "<span style=\"background-color:#76EEC6;\">" & "Not Scheduled" & "</span>", ToText([MUD DELIVERY]))
------------------------------
BuildPro
------------------------------
I need further assistance with this, please. I would like the [MUD DELIVERY] field to be colorized if there is no date in the field.
This is the formula I have used, but it seems to be doing nothing.
[HIGHLIGHT FIELD] - Rich text formula:
If(IsNull([MUD DELIVERY]), "<span style=\"background-color:#76EEC6;\">" & "Not Scheduled" & "</span>", ToText([MUD DELIVERY]))
------------------------------
BuildPro
------------------------------
I think I've got it to work. Thank you
------------------------------
BuildPro
------------------------------
------------------------------
BuildPro
------------------------------