Forum Discussion

AmazingRandom's avatar
AmazingRandom
Helper II
2 years ago
Solved

IF function with conditional formatting

I have been asked to prepare a table where values who surpass a threshold (180, 360, 900 or 1800) or equal to it are to be highlighted, as well as have any value less than 1800 to be represented as <...
  • SamInogic's avatar
    SamInogic
    2 years ago

    Hi AmazingRandom ,

    As per our understanding you have above mentioned data in your table and you want a way for applying background color based on your condition, then you need to create a custom column with below expression,

    Lab result 1 colour = if( CONTAINSSTRING('Table'[Lab Result 1], "<") || CONTAINSSTRING('Table'[Lab Result 1], "-") ,"","Yellow")

    Create individual columns for other 5 Lab Results and you can set the conditional formatting using Field Value as shown in the below screenshot,

     

    After applying same formatting to each column, this will result as below,

    Thanks!

     

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

SamInogic's avatar
SamInogic
Super User
2 years ago

Hi AmazingRandom ,

As per our understanding you have above mentioned data in your table and you want a way for applying background color based on your condition, then you need to create a custom column with below expression,

Lab result 1 colour = if( CONTAINSSTRING('Table'[Lab Result 1], "<") || CONTAINSSTRING('Table'[Lab Result 1], "-") ,"","Yellow")

Create individual columns for other 5 Lab Results and you can set the conditional formatting using Field Value as shown in the below screenshot,

 

After applying same formatting to each column, this will result as below,

Thanks!

 

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

AmazingRandom's avatar
AmazingRandom
Helper II
2 years ago

Hi! Thanks for your help! One question in case the client, if they were to prefer blank values over the "-" how would I edit the formula? I tried doing that but to no success

  • SamInogic's avatar
    SamInogic
    Super User
    2 years ago

    Hi AmazingRandom ,

    For null values you can simply update expression as below,

    Lab result 1 colour = if( CONTAINSSTRING('Table'[Lab Result 1], "<") || CONTAINSSTRING('Table'[Lab Result 1], "-") || 'Table'[Lab Result 1] = "" ,"","Yellow")

     

    Thanks!

     

    Inogic Professional Services Division

    Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

    Drop an email at [email protected]

    Services:  http://www.inogic.com/services/

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/