Skip to Content
0

isnull format cell

Jan 10 at 09:55 PM

35

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vitaly Izmaylov
Jan 29 at 11:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded