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 different from the other two
- If all three are dfferent
See below for example:
(the Date in SystemX is a text field)
I hope someone can help or give inspiration 🙂
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.
6 Replies
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?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.
Fairly simple task in Excel,
