Good day,
I am trying to use the below formula to change the color based on the results; it was validated. However, the error I can get it the array is outside warning bubble.
=IIf((DateDiff('d',[SOOrder.RequestDate],CDate([SOOrderShipment.ShipDate]),'>0,blue','red60')))
I made some changes but the same result or it is didn’t work to change the color based on >0 or <0.
Your assistance would be greatly appreciated.
Evan
Best answer by darylbowman
You put the formula in the ‘Data Field’ column instead of the ‘Style’ column, hence it showing the text ‘red60’ instead of the color.
+13Try this:
=IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])>0,'blue60','red60')
Hi
I appreciate the support below is the results. It works to identify the color but it is doesn't how the number.
Any suggestions. Maybe I need ‘ ‘ around around >0
+13You put the formula in the ‘Data Field’ column instead of the ‘Style’ column, hence it showing the text ‘red60’ instead of the color.
+7Hello
To have the entire row change colors based on a formula use Row Style field (1).
To have a single cell change colors based on a formula use the Style (2).
The value displayed in a column/cell will always be calculated from the data field. (3)
You can place
Thank you. Both suggestions worked perfectly. I appreciate your support.
Evan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
