Hello,
We have a GI that shows our Purchasing Dept. what needs to be re-ordered for items. I’ve been able to create the whole thing and use the Row Style to highlight High Priority items in ‘red’. They have asked if I could instead just make the color of the values ‘red’ instead of the entire row. Specifically the Qty. On Hand column. Picture below.
+4
Hi
For fonts, this would be the color which ends in 0, so red0.
I was working on my Service Order primary list and this was my function:
=IIF([FSServiceOrder.CuryBillableOrderTotal]>10000, 'red0','' )
This was my result:
This will turn the whole row with red font, but if you only wanted the column of values to turn conditionally red, you would use the style option in the Results Grid section instead of the Row Styles at the top of the results grid:
Result is:
Hope this helps!
It was the 0 after red I was missing. THANK YOU!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.