Conditional formatting with more than one condition where values are not numerical?

[Erika_S]

Hi all,

Hope someone could help.

Well, i was trying and haven't succeeded yet - to conditionally format columns based on other columns value that is not numerical. So for Example - column 1 - Manager name, column 2 - Employee names, column 3 - Country,  and i want to highlight all Employees who have manager Judy and are in Spain. (for example) 🙂 So its based on values that are not numbers. 

Can anyone help me with that? I use June 2019 Desktop version. 

Thanks a million.,

erika

[v-cherch-msft · Accepted solution]

Hi @Erika_S 

Yes,you can.For example:

Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)

Regards,

[v-cherch-msft]

Hi @Erika_S 

You may create a measure then use conditional formatting for Employee names like below:

Measure = IF(MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)

Regards,

[Erika_S]

Sounds really good !

Could I switch the IF for SWITCH, and use multipple conditions? do I use && if i want to say "this condition and this one"?

Sorry if my questions very simple.

Thank you for your help! its so helpful.

erika

[v-cherch-msft · Accepted solution]

Hi @Erika_S 

Yes,you can.For example:

Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)

Regards,

[Erika_S · Accepted solution]

Can I colour the backgroudn based on the result in the column, rather than creating new column with value 1 and 2?  Say Colour Manager name - Judy yellow, if name is Judy and Country is spain?

If not possible, this is a solution as well.  🙂

Thank you so much,

erika

[Erika_S]

Thank you, that works!! 🙂

erika

[evandrocunico]

Hi @Erika_S , have you tried to create a new column and fill with a color (hexa), and use field value (new column) on conditionally format?

Regards.

Evandro