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.

Hi Bret,

See the attached file for conditional format on the most current data.

What do you exactly mean with " ... if the condition is met." ?

Erik

Hi,

Instead of using ..

=EN(J5<>"";K5="";J$4<>"")

.. use this formula in the conditional format.

=EN(J5>=0,9;K5="";J$4<>"")

For what I know it is not possible to highlight the server name based on a variable last cell. Maybe someone else knows ?

It's probabbly because I'm using the Dutch version. Try :

=AND(J5>=0.9,K5="",J$4<>"")