Solved

Conditional Formatting

  • 7 January 2022
  • 4 replies
  • 664 views

Userlevel 5
Badge +8

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

icon

Best answer by PRODQ 7 January 2022, 14:29

View original

This topic has been closed for comments

4 replies

Userlevel 7
Badge +21

Hi @Thakshila 

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

 

Kind regards

Userlevel 5
Badge +8

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

Userlevel 6
Badge +13

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

Userlevel 5
Badge +8

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!