Hi Community,
I would like to colour the Used/Actual Hours in red if they are larger than the Baseline Hours. Is it possible to add a rule by using another column? If yes, how can we do it?
Thank you in advance!
Best regards,
Thakshila
Solved
Conditional Formatting
Best answer by PRODQ
You could add in a custom field that had a “if used/actual hours > baseline hours then ‘Yes” else “No” expression (or 0 and 1) and then conditionally format the row based on the custom field equalling “Yes” ...
This topic has been closed for comments
Link wrote:
Thank you for your quick reply. This is also App 9 environment
+17You could add in a custom field that had a “if used/actual hours > baseline hours then ‘Yes” else “No” expression (or 0 and 1) and then conditionally format the row based on the custom field equalling “Yes” ...
PRODQ wrote:
You could add in a custom field that had a “if used/actual hours > baseline hours then ‘Yes” else “No” expression (or 0 and 1) and then conditionally format the row based on the custom field equalling “Yes” ...
Hi, That’s a good idea. Thank you so much for your help!
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.