Conditional Formatting Assistance

I am in dire need of assistance.

I have attached an simplified version of the spreadsheet I am using but have removed all conditional formatting that I have been using.

Now, what I want to do it evaluate each row and if the last value for that row is X, then highlight that cell and the Server name for that row.

I have used conditional formatting but it seems that I cannot specify an option to look at the last cell in a row, evaluate that cell's value and then apply the formatting. I can only have conditional formatting highlight every cell in that row that matches the condition.

I only want the last cell, which represents the most current data, to be highlighted, as well as the category name, if the condition is met.

Anybody know of a way to accomplish that? All suggestions welcome and thank you in advance.