I found this inconsistency the other day.

It seems as though when using a date format on a merge field in conjunction with conditional formatting, conditional formatting fails.

See attached file.

ConditionalFormat_DateFormat.zip

Hi John

Try with:

Self = "Overdue " <-- there is a space in your custom date format ( second row after none ) !

Ah...

Thank you for catching the space Daniele. That was what was throwing my tests off...

So it does seem to be that Self takes the value of the custom date formatted merge field whereas with a field, Self will return the field value...

Interesting.

I think that Self refers to the entire text object - after all, that's what being conditionally formatted.

ConditionalFormat_DateFormat.fp7.zip

Indeed.