Skip to main content

Hi,

 I am writing to seek assistance in setting a specific condition for the background color in my Customer Order. Specifically, I am aiming to make the background color turn green when the "Desired Qty" is less than or equal to the "Available Qty."

Could you please guide me on how to formulate this condition properly? I would greatly appreciate any insights or examples you can provide.

Furthermore, if there are any relevant training materials or tutorials available that could aid me in understanding and implementing this condition, I would be grateful if you could share them with me.

Thank you for your attention to my request. 

Best regards,

You can’t conditionally format one column on the consideration of the value in another column.  The workaround is to create a custom field that does the logical work as a Yes/No value, then do the conditional formatting based on the custom field.

 

 


Reply