Skip to Content
avatar image
Former Member

isnull format cell

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 29 at 11:42 PM

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

    Add comment
    10|10000 characters needed characters exceeded