Conditional formatting problem

[ryangus]

I have an anticipated completion date, and a completion date. If the completion date is null, and the anticipated completion date is prior to the current date, I want the anticipated date to show up in bold red. Can someone please help with the formula?

 

[kenhamady]

Font Color Condition formula to turn Red:

if IsNull ({complete}) and {Anticipate} < CurrentDate
then Red
else Black

To get bold, you would also have to write the same formula for the appropriate Font property condition. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[ryangus]

Thank Ken,

I managed to work it out just before I was about to check back here!

Regards,
Ranga