Hello,
I am looking for a way to create conditional formatting for the available Qty column within Customer Order Lines. I am looking to have the cell highlight green if the value is greater than the Sales Qty (BUY_QTY_DUE). I am trying to put in the below formula, but it doesn’t look like conditional formatting has the ability to compare the value against a different column value. Is that accurate, or is there a way to accomplish this that I am missing?
Thank you,
Matt
That's acurate. You can create a custom field with your condition and then use that to colour the line the way you want though.
Great, thank you for the help!
Can you explain how to create conditional formatting for a custom field? What screen is it done from?
Can you explain how to create conditional formatting for a custom field? What screen is it done from?
What I mean is that you can create a custom field that does a calculation or looks up a value e.g. IF 2 > 1 THEN 5 else 2
Then you setup your conditional formatting rule using the custom field e.g. when custom field =5 paint the line green.
Okay, I understand now. Thank you!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.