isnull format cell

[Former Member]

I am trying to format cell backgrounds based on expiration dates and the ones that that have empty value format cells with a different color.

The cells that have an expiration date are formatting correctly. The cells that have no value are not formatting correctly. Please assist.

This is the current formula I have:

If isnull ({HR_EMPLOYEE_TRAINING_MC.Employee_Train_Exp_Date}) =true then crYellow

else

if {HR_EMPLOYEE_TRAINING_MC.Employee_Train_Exp_Date} < currentdate then crSilver

else

if {HR_EMPLOYEE_TRAINING_MC.Employee_Train_Exp_Date} >currentdate then crNoColor

[vitaly_izmaylov]

Not sure if it is the cause but IsNull function does not require "=true" part.