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
View original
+11
You put the formula in the ‘Data Field’ column instead of the ‘Style’ column, hence it showing the text ‘red60’ instead of the color.
+8
Hello
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
+11
Try this:
=IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])>0,'blue60','red60')
Thank you. Both suggestions worked perfectly. I appreciate your support.
Evan
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.