Forum Discussion
Conditional formatting with more than one condition where values are not numerical?
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
Hi Erika_S
Yes,you can.For example:
Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)
Regards,
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
6 Replies
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,
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
Hi Erika_S
Yes,you can.For example:
Measure 2 = SWITCH(TRUE(),MAX(Table1[Manager name])="Judy"&&MAX(Table1[Country])="Spain",1,2)
Regards,
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
