Skip to main content

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

Hi @Thakshila 

we use IFS App 9. It is not possible there.

 

Kind regards


Hi @Thakshila 

we use IFS App 9. It is not possible there.

 

Kind regards

Thank you for your quick reply. This is also App 9 environment


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” ...


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!