I currently have a Cross-Tab with the following lapout

Row Name   Column1   Column2   Column3

The Summarized Field is 'Max of {Date_Field}' to get the last date/time reported.

I'm now trying to conditionally format the background colour using this formula:

 If {Date_Field}<DateAdd('d',-1,CurrentDate) Then crRed else crNoColor 

However it either turns everything red or nothing red.... And not all dates meet or don't meet the condition.


Edited by Dr4ke - 23 Oct 2014 at 4:38am

legend. Thanks very much!