Conditional Format BGColor in Formula

[elead]

I need a pointer. I have the following formula planted in a group footer.

IIf({tblAutoRaw.dtAction}={?ReportStart}+1 AND {tblAutoRaw.szTermCode} <> &quot;TR&quot;,{tblAutoRaw.nCount},0)

What I want to do is make the background lightgrey if it falls on a Saturday or Sunday?

Thanks

 

[SmpTraining]

Right Click the field you need to change the color of, choose the Format Field option, select the 'Border' tab and set a condition against the 'background color' setting. Steve Phillips, Crystal Consultant