Forum Discussion
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...
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.
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.
Thank you! It works! 🙂