Conditional Formatting comparing cells between two rows

[CactusJackAZ]

Hello, we have two sets of two Tomcat servers that are in a load balance configuration, 4 servers broken down into 2 groups. 

For each group, we want to change the background color of the cell in the "Role" column if one server doesn't state Primary and another server doesn't state Secondary.  Basically for each pair of Tomcat servers, one should have the word Primary and a word Secondary under the Role column.  If not we want to change the background color to red.

Server Name	Role
TomcatA	Primary
TomcatB	Secondary
TomcatC	Secondary
TomcatD	Primary

[CactusJackAZ]

It's hard to really display what the expected outcome is but I agree I should try to state what I would like to see in better terms.

Right now we have the Secondary and Primary cells with a green background and white font.  I put a highlighted red box around each pair of servers.

I would like to make the green background turn red if there isn't a Secondary / Primary text combination in the field for either pair of servers.  At times the servers will change roles in each pair, yet there should always be a Secondary and a Primary server in each group.

APPD31 and APPD32 will always be a pair.  

APPD71 and APPD72 will always be a pair.  

[lbendlin · Accepted solution]

APPD31 and APPD32 will always be a pair.  
APPD71 and APPD72 will always be a pair.  

You know that but Power BI doesn't.  You need to provide a hint (like a Pair ID) in the data.

[CactusJackAZ]

Correct, I'll need to establish a relationship and then check the condition.  I'm quite new to Power BI and trying to do the balancing act of learning Power BI but with an understanding I will likely not use the application that much after this.

As for this case.  I created a simple bash script to complete the task and will update the DB table and use that value in the conditional formatting equation.

I will close this session but very grateful of the input you gave.  Being able to ask questions and get answers from the community makes the task of learning a new application easier.    

[lbendlin]

Please provide sample data that fully covers your issue. Right now there is no problem (apart from the missing group ID column).
Please show the expected outcome based on the sample data you provided.