Skip to main content
Solved

Conditional Formatting

  • January 7, 2022
  • 4 replies
  • 896 views

Forum|alt.badge.img+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

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

4 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • January 7, 2022

Hi @Thakshila 

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

 

Kind regards


Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • January 7, 2022

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


PRODQ
Superhero (Customer)
Forum|alt.badge.img+18
  • Superhero (Customer)
  • Answer
  • January 7, 2022

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


Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • January 7, 2022

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!