Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Formatting based on three text fields

Hi,   I am validating data from 3 different systems. I want to make a table like the example below where I can see for each row in the dimension where they are different, like: - Which one is diff...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Yes I can,

    I have added three columns to determine if an column should get a background color. 

    These are the formulas:

    conditional1 = if(and(Example[System1]<>Example[System2],Example[System1]<>Example[System3]),1,0)
    conditional2 = if(and(Example[System2]<>Example[System1],Example[System2]<>Example[System3]),1,0)
    conditional3 = if(and(Example[System3]<>Example[System1],Example[System3]<>Example[System2]),1,0)
    It gives you the following result:


    If a conditional 1 is 1 then you can choose a background color for system 1 etc.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey Xilitor!

I was thinking of creating an extra column where you determine if:
 - Column 1 is different then 2 and 3
- Column 2 is different then 1 and 3
- Column 3 is different then 1 and 2
- All columns are different.

Then, based on that new column you can apply conditional formatting. 

Is this something you can work with?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can you elaborate a bit more on that?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Yes I can,

    I have added three columns to determine if an column should get a background color. 

    These are the formulas:

    conditional1 = if(and(Example[System1]<>Example[System2],Example[System1]<>Example[System3]),1,0)
    conditional2 = if(and(Example[System2]<>Example[System1],Example[System2]<>Example[System3]),1,0)
    conditional3 = if(and(Example[System3]<>Example[System1],Example[System3]<>Example[System2]),1,0)
    It gives you the following result:


    If a conditional 1 is 1 then you can choose a background color for system 1 etc.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you! It works! 🙂